Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
Craig
 
Posts: n/a
Default Preserve formatting in Pivot Chart

I have a Pivot Chart with 2 sets of information. Each set is charted
differently (one is a column chart, the other a line chart). WHen I refresh
both sets default to column chart. Is there a way to preserve the Pivot
Chart formatting through refresh?
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope
 
Posts: n/a
Default Preserve formatting in Pivot Chart

Hi,

This is a know problem.

Changing a PivotChart removes series formatting in Excel
http://support.microsoft.com/default...;EN-US;Q215904

Cheers
Andy

Craig wrote:
I have a Pivot Chart with 2 sets of information. Each set is charted
differently (one is a column chart, the other a line chart). WHen I refresh
both sets default to column chart. Is there a way to preserve the Pivot
Chart formatting through refresh?


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
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
Exclude pivot table data from pivot chart? coal_miner Charts and Charting in Excel 4 April 17th 07 07:11 AM
Pivot Chart Report - formatting student Renee Charts and Charting in Excel 2 October 3rd 05 12:05 PM
Pivot Chart - default chart type Rav99 Excel Discussion (Misc queries) 4 September 6th 05 01:20 AM
Pivot Tables and Formatting Neily Excel Worksheet Functions 2 August 9th 05 03:08 PM
How do I change the category axis number formatting in a Pivot Ch. Cultcab Charts and Charting in Excel 0 April 19th 05 12:26 AM


All times are GMT +1. The time now is 12:05 PM.

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

About Us

"It's about Microsoft Excel"