#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,814
Default copy chart format

I have several pivot charts. On the first one I have all of the formatting
options the way I want them (e.g., fonts, colors, grid lines, etc.) Is
there a way to copy all of the formatting to another chart(s)?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default copy chart format

First you select the first one and make it a user-defined chart type under
Custom Types.

Then you apply that to all new charts or existing charts.


Gord Dibben MS Excel MVP

On Wed, 9 Sep 2009 09:01:01 -0700, Steve
wrote:

I have several pivot charts. On the first one I have all of the formatting
options the way I want them (e.g., fonts, colors, grid lines, etc.) Is
there a way to copy all of the formatting to another chart(s)?


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
Lock Cell Format - Allow copy and paste of data without format change Chris12InKC Excel Worksheet Functions 2 May 9th 23 07:42 PM
move or copy sheets doesn't copy format ColinX Excel Worksheet Functions 1 May 14th 08 10:07 PM
anyway to copy the chart format to another worksheet question on links where info is added an[_2_] Excel Discussion (Misc queries) 3 October 18th 07 01:39 AM
Copy Paste Chart format in Excel 2003 using VB.NET MacAndy Charts and Charting in Excel 1 May 28th 07 02:14 PM
copy conditional format to regular format GDC Setting up and Configuration of Excel 3 May 4th 05 09:35 PM


All times are GMT +1. The time now is 05:19 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"