Chart Wizard Data Point Alignment

[kingofthekassel]

Hey everyone,



So I have been creating a graph using chart wizard and everything is working great! The last thing I would like to do is make it so the data points show up in the center of a box instead of at the grid point. I have attached a very crude example of what I want vs. what I have. In the process I would also like to get the axis numbers to show up in between each grid line. The one labeled "have" is what my chart pretty much looks like in Access. The picture labeled "needed" is my goal in Access. I appreciate the help.

[kingofthekassel]

I just realized the file names didn't show up so the one on the left is what I need, the one on the right is what I have. Also the points aren't in corresponding correct places, but that's irrelevant.

[June7]

Don't think Access graphing can handle that. However, if you want to provide db for analysis, I will look at. Follow instructions at bottom of my post.