two colored graph

[jfillioe]

i regularly create line graphs that include current data and projecte
data. i can change the line colors but i would like to change th
color of the grids so that the projected portion of the graph i
different than the grids for the curent data. using the gradient fil
option is not acceptable. any way???

thank

 

[Jon Peltier]

You could construct custom gridlines using error bars:

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

You would need one dummy series per color, since all error bars in a series are
formatted the same.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______