![]() |
Pivot Chart Report
I am working with a pivot table that displays Month and Category type in the
Rows and Average Margin is the data. So the resulting pivot table displays the average margin for each month and within that month the average margin by category type. I am now trying to create a pivot chart. However, the result is that on the horizontal axis I have three category types for January and then the other three for February. What I would like to see is all six grouped together for January and then the same for February with each category defined by a different color type. How would I do that? Thanks for your help. |
All times are GMT +1. The time now is 01:11 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com