Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Pivot chart formats
I would like to know how to keep my formats on an excel pivot chart, I have
read the help on vba and opened up view code but I am unsure of what code goes in next ??? there does not seem to be any examples anywhere please help |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Pivot chart formats
You can record a macro as you format the pivot chart.
Then, assuming the chart is on a chart sheet -- Right-click on the chart sheet tab, and choose View Code From the dropdown list at the top left, choose Chart From the dropdown list at the top right, choose Calculate Paste your code where the cursor is flashing, e.g.: Private Sub Chart_Calculate() With ActiveChart.SeriesCollection(3).Interior .ColorIndex = 37 .Pattern = xlSolid End With End Sub You may have to modify it a bit, but that should help you get started. kate wrote: I would like to know how to keep my formats on an excel pivot chart, I have read the help on vba and opened up view code but I am unsure of what code goes in next ??? there does not seem to be any examples anywhere please help -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Pivot chart formats
"Debra Dalgleish" wrote: You can record a macro as you format the pivot chart. Then, assuming the chart is on a chart sheet -- Right-click on the chart sheet tab, and choose View Code From the dropdown list at the top left, choose Chart From the dropdown list at the top right, choose Calculate Paste your code where the cursor is flashing, e.g.: Private Sub Chart_Calculate() With ActiveChart.SeriesCollection(3).Interior .ColorIndex = 37 .Pattern = xlSolid End With End Sub You may have to modify it a bit, but that should help you get started. kate wrote: I would like to know how to keep my formats on an excel pivot chart, I have read the help on vba and opened up view code but I am unsure of what code goes in next ??? there does not seem to be any examples anywhere please help -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html thankyou for your help its appreciated |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pivot table formats | Excel Discussion (Misc queries) | |||
Pivot Chart Formats | Charts and Charting in Excel | |||
How to keep formats in pivot? | Excel Discussion (Misc queries) | |||
Pivot table formats | Excel Discussion (Misc queries) | |||
copying excel chart formats from one chart to another | Excel Discussion (Misc queries) |