Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|