| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| spreadsheet gridlines as graph paper | Excel Discussion (Misc queries) | |||
| How do I create a combination graph with stackedColumns+lineGraph | Charts and Charting in Excel | |||
| Graph Help- 12 month graph, but only want months that have passed | Charts and Charting in Excel | |||
| Line Graph Data Recognition | Charts and Charting in Excel | |||
| Graph Axes | Excel Discussion (Misc queries) | |||
Hybrid Mode
