 |
 |
 |
 |
 |
|
|
||||||||||||
|
#1
10-25-2005, 02:05 PM
|
|||
|
|||
|
How do I add gridlines on a graph?
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. 
|
|
#2
10-25-2005, 05:05 PM
|
|||
|
|||
|
Re: How do I add gridlines on a graph?
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
|
 |
| Bookmarks |
New topics in Excel Charting
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
