ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How do I reset the default colours in a line graph (https://www.excelbanter.com/charts-charting-excel/79977-how-do-i-reset-default-colours-line-graph.html)

AIHW

How do I reset the default colours in a line graph
 


Jon Peltier

How do I reset the default colours in a line graph
 
You mean, how do you change the default values? Tools Options Color tab,
and change the colors in the bottom row or two of the palette ("Line
Colors").

Or do you want to undo the custom formatting you applied and now hate?
Double click each series, and change all the settings on the Patterns tab to
Automatic.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______

"AIHW" wrote in message
...





All times are GMT +1. The time now is 08:46 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com