Pivot Chart Formating

B

bayo2008

I like to be able to keep changes I made to pivot chart even when I refresh
data or change the cell reference for underlying the pivot table
 
D

Debra Dalgleish

Loss of formatting is a known problem with pivot charts. There's
information in the following MSKB article, which suggests recording a
macro as you apply the formatting:

Changing a PivotChart removes series formatting in Excel
http://support.microsoft.com/?id=215904

Or, if you're just changing the colours, instead of changing the colours
in the pivot chart, you could modify the standard colours in the workbook:

On the Tools menu, click Options
Click the Color tab
In the row of Chart fills, click on the first colour block
Click the Modify button
Select the colour that you want, then click OK
Change any of the other fills or Chart lines colours, then click OK
 

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