pliskers
Active Member
- Joined
- Sep 26, 2002
- Messages
- 462
- Office Version
- 2016
- Platform
- Windows
Hello, Excel masters!
I know this is cited as an Excel flaw, but I'm hoping some event code can work around it. I have a Combo Pivot Chart showing one measure as clustered bars on the primary axis, and a line chart that uses the secondary axis. Whether using a page-by pivot filter or a slicer, once I've set up the chart, any filter change removes the secondary axis and changes all measures to the clustered bars.
The metric that uses the line chart and the secondary axis will have "ROS" in every element. Is there some code that I can paste into the chart page to 1) set all ROS metrics to a line chart, and 2) use the secondary axis for all of the ROS metric elements?
Frustrating!
I know this is cited as an Excel flaw, but I'm hoping some event code can work around it. I have a Combo Pivot Chart showing one measure as clustered bars on the primary axis, and a line chart that uses the secondary axis. Whether using a page-by pivot filter or a slicer, once I've set up the chart, any filter change removes the secondary axis and changes all measures to the clustered bars.
The metric that uses the line chart and the secondary axis will have "ROS" in every element. Is there some code that I can paste into the chart page to 1) set all ROS metrics to a line chart, and 2) use the secondary axis for all of the ROS metric elements?
Frustrating!
