Excel 2007 Charts Gridlines through Data points

  frager 14:24 21 Feb 10

I have set up a spreadsheet to record my weight in kgs every week. The dates are in Column A and the weights are in column B.
I have created a line chart to show the changes.
How do I get the vertical gridlines to go through the data points?
At the moment the data points are to the right of the gridline.
I knew last year how to do this but have forgotten.
I’m using Excel 2007 and Vista Home Premium

  Woolwell 18:12 21 Feb 10

Click on the axis and right click format axis. Then on Axis Options - Position axis on tick marks should do what you want.

  frager 19:31 21 Feb 10

Thanks Woolwell. It was the 'Right Click' that solved my problem

  johnnyrocker 20:13 21 Feb 10

a resolved tick would be nice


  frager 21:42 21 Feb 10

I appreciate your comment.
I did check the Resolved box, but for some reason the check mark did not make it to the Forum

  frager 22:08 21 Feb 10

The fault was mine.
I did check the Resolved box but then forgot to click Resolved.


This thread is now locked and can not be replied to.

Huawei P10 review

1995-2015: How technology has changed the world in 20 years

An overview: What leading creative agencies are doing to improve diversity

New iPad, iPhone SE & Red iPhone 7 on sale now