Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
More PivotTable Trouble
Good morning..
I have a customized PivotChart with everything just the way I like it. Specifically, the data labels on the columns are vertical and font size is 8. When my user changes the Page Field value, the font size jumps back up to 12 and the alignment turns to horizontal again. Autoscale isn't helping me, either. I can't find an event to capture of the Worksheet/Workbook objects to change the labels back. Input please? Thank you. -Brad |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
More PivotTable Trouble
Hi Brad
I've had similar problems with line colors on pivot charts changing. This worked for me: Private Sub chart_calculate() Call StandardColors End Sub As you know the code goes in the chart sheet. You probably need to track the change in the cell that displays the page field. Mike -----Original Message----- Good morning.. I have a customized PivotChart with everything just the way I like it. Specifically, the data labels on the columns are vertical and font size is 8. When my user changes the Page Field value, the font size jumps back up to 12 and the alignment turns to horizontal again. Autoscale isn't helping me, either. I can't find an event to capture of the Worksheet/Workbook objects to change the labels back. Input please? Thank you. -Brad . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivottable | Excel Discussion (Misc queries) | |||
Creating a PivotTable w/o selecting data in an existing PivotTable | Excel Discussion (Misc queries) | |||
Pivottable | Excel Discussion (Misc queries) | |||
PivotTable | Excel Worksheet Functions | |||
Creating a PivotTable Report from an Another PivotTable Report | Excel Programming |