|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
October 19th, 2004, 11:55 PM
|
|||
|
|||
Chart Format generated from a Pivot Table Data
After I Format a Chart generated from a Pivot table Data, and I change a
selection, for example "Plant".. Al the information on the chart changes, according to the new plant selection, but, why the Chart Type and the format also changes too... I need to keep the same chart type and format to keep reviewing the information for the rest of the plants.... with the same chart type and format. 
|
|
#2
October 20th, 2004, 05:58 AM
|
|||
|
|||
|
Microsoft admits they goofed that one up:
XL2000: Changing a PivotChart Removes Series Formatting http://support.microsoft.com/?id=215904 They suggest you record a macro, so you can reapply the format whenever the pivot table is updated. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Victor wrote: After I Format a Chart generated from a Pivot table Data, and I change a selection, for example "Plant".. Al the information on the chart changes, according to the new plant selection, but, why the Chart Type and the format also changes too... I need to keep the same chart type and format to keep reviewing the information for the rest of the plants.... with the same chart type and format.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How to extract original data from a pivot table? | cmagnus98 | General Discussion | 1 | July 9th, 2004 03:55 PM |
| Chart from Pivot table | Adam | General Discussion | 1 | June 23rd, 2004 12:58 PM |
| Probs with creating multiple pivot charts from pivot table | Retreatgal | Charts and Charting | 2 | January 28th, 2004 02:51 AM |
| can I hide a series in a stacked bar chart but keep the series in the data table | Stephen Bullen | Charts and Charting | 0 | December 5th, 2003 10:53 AM |
| Help with Data (Table) below my chart | Jon Peltier | Charts and Charting | 0 | November 20th, 2003 03:36 PM |
Linear Mode
