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

D

deedee3

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?
 
J

Jon Peltier

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/
_______
 

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

change color of curve line as time changes 2
Odd Chart Format Results 1
excel 2007 line weight in legend does not match the chart 0
Convert Error Bars to Series and Colour 1
Excel 2007: Stacked column chart with white data labels 2
series coloring inconsistent across charts 0
Color Text in Charts 1
For chart syles, why doesn't color order match series order? 1

Top