Removing Grid Lines

[gehusi]

How can I delete specific grid lines from a chart in Excel 2003? For example, say I have major grid lines at 0, 20, 40, 60, 80, and 100. I'd like to remove just the grid line at 100, while leaving the others intact. Is this possible?

 

[Cease]

The only way I know is to remove gridlines from the sheet and put in borders where you need them.

This can give you a much more custom set of lines throughout the sheet, and you can choose all the different styles and whatnot.

Don't know if that will help or not, but it's my $.02

Hope it helps!

 

[Claymationator]

Check out this link on how to make arbitrary grid lines in your charts. Other than that I don't think it is possible to turn off only one grid line.

http://peltiertech.com/Excel/Charts/ArbitraryGridlines.html

Hope that helps.