Access bar chart date axis
Posted on 2010-09-23
I have a number of charts in Access 2007 created with MS Graph that I would like to have a horizontal date axis in months.
Currently the axis displays months because I have set the axis majorunit to 365.25/4 and the minorunit to 30.4375 which produces a result that is close but the first date is 1-Aug-07 and the next date is 31-Oct-07. I am not really interested in the one day descrepancy but the axis is confusing to read because the day error changes the month so, for example the 31-Oct-07 would look a lot better if it was 1-Nov-07.
I would like to specify the start date and end date and specify the units as months instead of 30.4375 days so each majorunit starts with the same day of the month. How do I specify the unit as 'months' rather than days?