How to display gridlines at irregular intervals?

J

Jason Weiss

Hi,

I'd like to display just two gridlines on a bar chart where the values range
from 0 to 100. The problem is, the gridlines that I'd like to display are
at 20 and 90. I can't seem to select and change the colors of individual
gridlines through the Excel interface or through VBA (not that I can tell,
anyway). Is there any way to do this other than manually drawing lines at
those intervals?

Thanks to anyone who can help. BTW, I'm using Excel 2000...

....Jay
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

2007 line chart, can't make some gridlines heavier than others 10
Adding Gridlines to an XY Scatter Area Chart 1
Multi-Level Category Gridlines 3
How do I add gridlines on a graph? 1
Can you alternate background colors by gridline? 1
display gridlines 5
Chart gridlines over an area graph 2
Copying excel chart to word document without gridlines 1

Top