Format vertical gridlines.

[Ian Betteridge]

Hello All,
I have a chart with weekly dates on the horizontal axis.
27/02/2012 to 25/06/2012
The vertical gridlines are currently shown for everyday.
Q. Is it possible to have the gridlines shown on a weekly format and not daily?

Regards Ian

 

[Steve=True]

Try changing the X axis major unit to 7

Steve=True
www.exceldashboardtemplates.com