#1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 270
Default Chart Formatting

Is there an easy way to copy the formatting of an entire chart to another
chart. Or can I change the defaults?
Sandy


  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 4,393
Default Chart Formatting

Create a custom chart style; see
http://peltiertech.com/Excel/ChartsH...stomTypes.html
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Sandy" wrote in message
...
Is there an easy way to copy the formatting of an entire chart to another
chart. Or can I change the defaults?
Sandy



  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 270
Default Chart Formatting

This is going to save me a lot of time - Brilliant.
Thanks Bernard
Sandy

"Bernard Liengme" wrote in message
...
Create a custom chart style; see
http://peltiertech.com/Excel/ChartsH...stomTypes.html
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Sandy" wrote in message
...
Is there an easy way to copy the formatting of an entire chart to another
chart. Or can I change the defaults?
Sandy





  #4   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default Chart Formatting

You can also copy one chart, then select another chart and use Paste Special
Formats to apply the formats to the second chart. Note: this also

overwrites axis and chart titles using the first chart's text.

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


"Sandy" wrote in message
...
This is going to save me a lot of time - Brilliant.
Thanks Bernard
Sandy

"Bernard Liengme" wrote in message
...
Create a custom chart style; see
http://peltiertech.com/Excel/ChartsH...stomTypes.html
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Sandy" wrote in message
...
Is there an easy way to copy the formatting of an entire chart to
another chart. Or can I change the defaults?
Sandy







Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
chart formatting Zahilly Excel Discussion (Misc queries) 0 June 19th 06 07:34 PM
Pivot Table border formatting and pivot chart formatting [email protected] Excel Discussion (Misc queries) 0 July 22nd 05 02:22 PM
Chart formatting Christianovitch Charts and Charting in Excel 1 January 19th 05 10:55 PM
Chart formatting Christopher Anderson Excel Discussion (Misc queries) 1 December 17th 04 04:53 AM
Formatting for a chart Woody13 Excel Discussion (Misc queries) 1 December 9th 04 03:17 AM


All times are GMT +1. The time now is 03:59 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"