Access MS Graph date axis
Posted on 2010-09-16
I'm using Access 2007 to create a graph with text values on the vertical (x) axis
and dates on the horizontal (z) axis. I don't know what happened to the y axis, it's disabled.
I can't get the z axis to display dates (year and month or any date) because the Date Value option doesn't display as an option .
The data table is in the format:
Description datevalueA datevalueB
I want the graph to display a bar starting at datevalueA extending to datevalueB parallel to the z axis (i.e. horizontal bars) and display the Description label on the x axis.