Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Delete selected major gridlines in a chart
I have an x axis with the values -50, -40, -30, -20, -10, 0, 10, 20, 30 with
all values in %. I would like for only gridlines to be displayed at the -20 and 0 points along the axis. How can I do this? I have not found a solution yet searching on the web. thanks |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Delete selected major gridlines in a chart
Gridlines come as a set. You can remove them all, assume the crossing
axis can represent the 0 value, and use one of these techniques to add a line at -20: Add a Line to a Column or Line Chart http://peltiertech.com/Excel/Charts/AddLine.html - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ Caldo wrote: I have an x axis with the values -50, -40, -30, -20, -10, 0, 10, 20, 30 with all values in %. I would like for only gridlines to be displayed at the -20 and 0 points along the axis. How can I do this? I have not found a solution yet searching on the web. thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving locations of major, secondary gridlines | Charts and Charting in Excel | |||
minor and major gridlines | Charts and Charting in Excel | |||
ScatterPlot Major and Minor Horizontal Gridlines not showing | Charts and Charting in Excel | |||
Help with adding x-axis major gridlines | Charts and Charting in Excel | |||
Value Axis Major Gridlines | Charts and Charting in Excel |