J
jvdb
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
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