Date on the x-axis of a graph in a report 2

[sonikudi]

hey guys,


i have a report in access that shows a buncha graphs, it takes the information to be graphed from a table. An event in the form triggers the query which creates the table and which in turn creates the graphs in the reports. The query has a date parameter. so say the user enters dates between 8/1/07 - 9/1/07 ..not all the dates have information associated with it. But the graph however shows dates for every week.....the graph is to be sent to the vendors and i am afraid it could be mis-understood..is there any way to make it such that the x-axis strictly only show all those dates for which there is a y-value from the table?? and if yes then how..

thanks for any help on this!

 

[genomon]

In the graph design environment, try Chart|Chart Options Axes tab - set primary axis to "category" instead of "automatic".

When everything is coming your way, you're in the wrong lane.

 

[sonikudi]

THANK YOU! genomon. I have been trying to fix this thing for a while now..it worked.. thanks again!

 

[genomon]

Glad it worked! The graph tool isn't very well documented or intuitive...


When everything is coming your way, you're in the wrong lane.