Graph X Axis Spacing? (1 Viewer)

[Toff]

This is on Access 2010 and graphing still sucks ...

Just trying to do a line graph.

My X Axis just will not auto space itself for the available data meaning it is showing most of the data (on the X axis, Y axis is fine). Theres tons of room as the space between X data points can be shortened a good bit if I could actually tell it to do it.

Am I missing an option somewhere? I hope I am.

Also in the graph object design mode, it shows the spacing perfectly. It does not translate over to view mode the same however.

I see a "Gap Width" option within the options of the data line but it is set to 150 and greyed out so I cannot change it.

Thanks

 

[Toff]

On further experimenting, it seems the the graph is displaying 2 months less data per year (weekly data points) despite all data being there and the Design View looking fine. I'm just gonna stick in more weekly dates then it really needs. 8 weeks extra per year displayed seems to work fine.

Unless someone has a real fix.