[SOLVED] How do I add gridlines on a graph?

[James Blake]

Ok, I am doing a chart with two X axis' and two Y axis. The X axis' are years
(from 1970-now) and the other X axis is the US Administrations for these
years. Now what I want to do is have vertical gridlines coming down at the
start of each administration (obviously different lengths due to different
terms). But the option I have been given on excel is for minor or major
gridlines, which seems to be an all gridlines on or no gridlines on approach.
So does anyone know how to put specific gridlines on the chart.

[Andy Pope]

Hi,

Sounds like you need to be creating your own gridlines. This should help.
http://peltiertech.com/Excel/Charts/...Gridlines.html

Cheers
Andy

James Blake wrote:
> Ok, I am doing a chart with two X axis' and two Y axis. The X axis' are years
> (from 1970-now) and the other X axis is the US Administrations for these
> years. Now what I want to do is have vertical gridlines coming down at the
> start of each administration (obviously different lengths due to different
> terms). But the option I have been given on excel is for minor or major
> gridlines, which seems to be an all gridlines on or no gridlines on approach.
> So does anyone know how to put specific gridlines on the chart.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info