Pivot charts formatting
Not directly. The only way to simulate this is to record a macro of the
formatting changes that you make and then set it up to run whenever the
PivotChart calculates. Assuming your pivot chart is on a seperate sheet,
right click on sheet tab and put something like this in:
Option Explicit
Private Sub Chart_Calculate()
'Insert your recorded macro here
'of the formatting changes that you need done.
'This will located in one of your modules
End Sub
--
Best Regards,
Luke M
*Remember to click "yes" if this post helped you!*
"DKS" wrote:
Hi,
I want to change the formatting imposed by default in a pivot chart and I
want that changed formatting to be retained permanently.
For example, for my bar chart, for the different series I have selected
colours / patterns but every time I refresh the pivot table / chart; excel
falls back to its own colour coding.
Any way to get around this?
Many thanks in anticipation.
|