| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro to keep chart dual axis format
Hi!
I have created pivot table and pivot chart. in pivot chart i have three series - Actual, Target and Variance. i have put Variance series as dual axis - (format - selected data series - secondary axis). but when i have new data and when i refresh pivot table, this format for variance gets change and i have to set up again this as secondary axis format. so i need help to create macro to keep this settings. Thanks! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
macro to keep chart dual axis format
Kay,
Feel free to contact me via my website & I will assist you. -- http://HelpExcel.com "kay" wrote: Hi! I have created pivot table and pivot chart. in pivot chart i have three series - Actual, Target and Variance. i have put Variance series as dual axis - (format - selected data series - secondary axis). but when i have new data and when i refresh pivot table, this format for variance gets change and i have to set up again this as secondary axis format. so i need help to create macro to keep this settings. Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Consolidate my data and plot on a dual axis chart | Charts and Charting in Excel | |||
| Colour plot area of a dual axis x,y chart | Charts and Charting in Excel | |||
| Dual Axis Horizontal Bar Chart in Excel-can I avoid overlapping ba | Charts and Charting in Excel | |||
| Dual x-axis chart | Charts and Charting in Excel | |||
| Chart with dual Y axis data | Excel Worksheet Functions | |||
Linear Mode
