Pivot charts formatting

D

DKS

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.
 
L

Luke M

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top