How do I change all chart colors to black and white?
 

I am plotting hourly values for a year. I need to have all the data series
represented as thin black lines, but EXCEL prefers a huge range of colors and
dashed lines along with solid lines. How can I force it to show all the data
series the same way, and make them all thin black lines?

Double click on one series, choose the format you want, and press OK.
Select another series and press the F4 key to repeat, Select and press
F4 for each of the other series.

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

deedee3 wrote:

I am plotting hourly values for a year. I need to have all the data series
represented as thin black lines, but EXCEL prefers a huge range of colors and
dashed lines along with solid lines. How can I force it to show all the data
series the same way, and make them all thin black lines?