How do I reset the default colours in a line graph

J

Jon Peltier

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
_______
 

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

Can I make a graph using several tabs in an excel spreadsheet 0
How can I put two variables with different scales on the same char 0
Change data range graph from 0-60 to 40-60 0
How do I resize the columns in a graph chart? 5
How do I create charts having non absolute reference values? 0
How do you make a hole in a line graph? 2
how do i graph gender & age in in a line graph? 1
How do I make my data points not overlap in a scatter plot? 1

Top