View Single Post
  #1   Report Post  
Jason Weiss
 
Posts: n/a
Default How to display gridlines at irregular intervals?

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