Change the default chart colours

G

Guest

When I create a pivot bar chart there are preset default colours. I can
change the colours but when I refresh the data the colours change back to the
original ones. How do I keep the same colours?
 
J

Jon Peltier

If it's just the colors you don't like, you can change the default colors in a
chart. On the Tools menu, choose Options, then click on the Color tab. The bottom
two rows of the palette are used for charting. Adjust them as you see fit. When
you've customized a workbook's palette (it's not Excel-wide, but stored with the
workbook), you can copy it into another workbook from the same dialog.

- 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

How do I lock the colours in a chart (red, amber, green) 2
How can I customise colours used in charts and keep those colours. 2
Pivot charts background with 3 different colours? 0
Pivot charts formatting 1
Charts change colour in 2003 2
How do i change the stack of colours chart to values not percent? 1
Surface chart - number of catergories 1
Chart Styles 1

Top