Hi all!

i have a pivot chart as a subform, and it is possible to change only the
data(not the format) by entering some other data in the mainform.

office 2003

the settings are(by using the properties window):

general settings of the chart area:

tab details
 detailrecords = enabled

tab charttype
 charttype = line

settings of the x-axis(using date's as x-values):

tab format:
 mm/dd/yyyy

tab scale:
 timescaling:                manual
 grouping and totals:    standard
 group size:                 1  days
 dimensions labels:      1  years
 dimensions:               1  years

(sorry but i m using the dutch version, so i dont know the exact
translations office uses in the english version, but the settings will be in
the same order as given above)

Now the question:

Often(not always) the group size change from days to years, so now i want to
know if there is a vb-code that can change it back to days if it is changed,
because otherwise the scaling isn't correct anymore. Or maybe there is even a
better solution?

thanks anyway

jvdb