Two-Axes Pivot Table Chart
Hi Folks - Here's my dilemma ...I have a pivot table that looks like this:
Cat1 Cat2 Cat3 Unit Data Unit1 SumOfCatCount 50 60 70 CountOfCat 1 2 3 Unit 2 SumOfCatCount 55 60 70 CountOfCat 3 4 3 Unit3 SumOfCatCount 75 75 80 CountOfCat 2 5 1 I can make a nice stacked chart out of the SumOfCatCount. I'd like to have a secondary axis with the CountOfCat. Do-able? Thanks, Michael |
All times are GMT +1. The time now is 09:56 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com