Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 29th 04, 09:37 PM
Big Red
 
Posts: n/a
Default using the PIVOT TABLE and CHART

When using the pivot table and chart in excel, I want to format the chart to
have distinct data series formats. However, when I change the selection in
the pivot table, the charting formats return to the defaults. I want to keep
this chart formatting regardless of how many time the data displayed is
changed. Is this possible?

  #2   Report Post  
Old November 29th 04, 09:42 PM
Debra Dalgleish
 
Posts: n/a
Default

Loss of formatting is a known problem with pivot charts. There's
information in the following MSKB article, suggests recording a macro as
you apply the formatting:

XL2000: Changing a PivotChart Removes Series Formatting
http://support.microsoft.com/?id=215904


Big Red wrote:
When using the pivot table and chart in excel, I want to format the chart to
have distinct data series formats. However, when I change the selection in
the pivot table, the charting formats return to the defaults. I want to keep
this chart formatting regardless of how many time the data displayed is
changed. Is this possible?



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html



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
How do I show summary totals from a pivot table on a bar chart Colleen T Charts and Charting in Excel 5 January 22nd 05 02:41 AM
changing proportion of chart and data table Dawn Parks Charts and Charting in Excel 3 January 6th 05 02:18 AM
Jon Peltier - Pivot Table Result for yesterday's "Complex Chart" Question Barb Reinhardt Charts and Charting in Excel 3 December 8th 04 02:48 AM
create space in line chart between points, linked to pivot table Mike -Z- Charts and Charting in Excel 1 December 7th 04 10:39 PM
pivot table multi line chart souris Charts and Charting in Excel 2 December 7th 04 04:56 AM


All times are GMT +1. The time now is 01:58 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017