Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Chart Changes Data Labels Formatting
From the charting FAQ, "Microsoft suggests recording a macro to apply your
custom formatting, then rerunning the macro after changing the pivot table." http://pubs.logicalexpressions.com/P...?ID=209#jon026 - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Amit Patel" <Amit Patel @discussions.microsoft.com wrote in message ... Hi, I am making pivot chart using pivot table, which shows me project performance based on [parameter YEAR (eg. 2004/2005/2006/ALL )] In which i am FORMATTING the data labels , but once i changes the parameter Year like say changed from 2004 to 2005 or ALL it immediately changes the DATA LABELS format to default one. How can i fix it or define a specific format for all values weather i change the parameters or not. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting pivot chart axis labels for dates | Charts and Charting in Excel | |||
Pivot Chart Data Labels Disappear | Excel Discussion (Misc queries) | |||
Pivot Chart - X-axis labels when adding data | Charts and Charting in Excel | |||
Pivot Chart Data labels | Charts and Charting in Excel | |||
How do I get my data labels on a pivot chart to retain their form. | Charts and Charting in Excel |