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 |
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 |
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 |
All times are GMT +1. The time now is 04:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com