ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Is it possible the change the default chart formatting. (https://www.excelbanter.com/charts-charting-excel/63496-possible-change-default-chart-formatting.html)

Kingston999

Is it possible the change the default chart formatting.
 

Every time I plot a chart, I have to change the default text sizes and
formats, turn off auto resizing, change the axis thickness and
background colour to get them looking how I want them.
Is there any way to do this automatically - changing the default
chart format?


--
Kingston999
------------------------------------------------------------------------
Kingston999's Profile: http://www.excelforum.com/member.php...o&userid=11800
View this thread: http://www.excelforum.com/showthread...hreadid=498648


Jon Peltier

Is it possible the change the default chart formatting.
 
Make a chart, format it completely, then define a custom chart type from it:

http://peltiertech.com/Excel/ChartsH...stomTypes.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

"Kingston999"
wrote in message
...

Every time I plot a chart, I have to change the default text sizes and
formats, turn off auto resizing, change the axis thickness and
background colour to get them looking how I want them.
Is there any way to do this automatically - changing the default
chart format?


--
Kingston999
------------------------------------------------------------------------
Kingston999's Profile:
http://www.excelforum.com/member.php...o&userid=11800
View this thread: http://www.excelforum.com/showthread...hreadid=498648





All times are GMT +1. The time now is 12:20 AM.

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