I am no chart expert! I inserted a line chart that looks against a pivot. I did not like the color choices fro the lines so I clicked the legend and chose others and at different weights. It looks great until I change or refresh the pivot. Then most of my formatting goes bye bye....what gives?
Hi there,
This is a common known issue with pivot charts.
What you need to do is the following:
- Start recording a macro
- Format the chart to your needs
- Stop recording the macro
- in the Visual basic editor (ALT F11) double click on the name of the sheet containing the sheet with the pivot table.
- Create a pivot table update event procedure and put the macro code in there.
This makes sure that the formatting is applied every time you change the pivot chart.
Hope this helps, and if you don't succeed, just post a sample file so someone can help you out.
J.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks