need to change color default settings for charts

G

GiGi

not finding anything in Help or Office online. Anyone
know how I can change the default settings for charts?

Thanks.
 
J

JulieD

Hi
you can format a chart etc as you want all new charts to look, add it in
under chart / chart type as a user defined chart & then set it as default
and all new charts will take the look of this one.

Hope this helps
Cheers
JulieD
 
J

Jon Peltier

If it's just the colors you want to change, you can adjust the
workbook's color palette. Choose Options from the Tools menu, and click
on the Color tab. Modify the bottom two rows of colors to adjust the
fill colors and line colors in Excel's default charts.

If it's all the other chart formats, follow Julie's advice and create a
few custom chart templates.

- 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

Changing defauls in 2019 0
Filtered view of Visio Chart 0
Visio 365 Change default connector arrow style 0
creating new template - change default heading style 7
Move Chart with Text 0
Match table shading (color) to Visio color/Transparency 1
Need help modifying code 0
Tracked changes by multiple people modified to one 0

Top