How to set the color of series in a graph

[archhabra]

Hi,

I am creating two graphs with series highest and lowest and i have kept the color of series as Automatic in Graphs.

But both the graphs are giving different colors for series and i am not able to figure out how to make sure both graphs will have same set of colors for series.

I need to do this from UI only.

Please let me know how to make sure both graphs will use the same color for same series by keeping the fill option as Automatic.

Regards
Arti

 

[Steve=True]

In Excel 2007 and probably 2010 highlight your graph you like under the Design ribbon click on Save As Template in the Type section, you can create a template for your chart that you can apply to new charts.

Not sure if this is a feature in 2003.

 

[TiaXL]

Right click on the data series goto format data series, here you can change the color line weight etc etc.

 

[archhabra]

Hi,

In format Data series i have already marked it as automatic.... so i am expecting the colors of all graph should come as similar but its not working...is there any way to make sure the automatic will apply the same colors to all graphs.