If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Pivot Chart Formatting
How can I format a Pivot Chart and keep the customized format when refreshed?
|
#2
|
|||
|
|||
Pivot Chart Formatting
This is a known issue by Microsoft.
Short answer, you can't do it. =( One possible work around is to record a macro of you setting the formatting of the chart, and then set it up so that the macro runs whenever the chart calculates. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Germeny Santos" wrote: How can I format a Pivot Chart and keep the customized format when refreshed? |
#3
|
|||
|
|||
Pivot Chart Formatting
Hi,
This is dependent on what custom formatting you are refering to. There are work arounds for some of the problems. One work around is to purchase 2007, this problem has been fixed in most areas, however there are still workarounds for 2003. As mentioned you can record a macro which does your custom formatting and then run it from the Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable) End Sub event macro. If this helps please click the Yes button. Cheers, Shane Devenshire "Germeny Santos" wrote: How can I format a Pivot Chart and keep the customized format when refreshed? |
Thread Tools | |
Display Modes | |
|
|