Log In
Register
Home
June 1, 2018
Offline
Hello, I have a problem of generating a meaningful chart in excel, please see attached file. The data is from pivot table, and I can get a pivot chart out of it, but I have a feeling that the normal chart has more flexibility to manipulate?
many thanks!
July 16, 2010
Offline
I think the best you can do with this data is a bar chart, assuming you want it all in one chart. If you add Slicers you can filter the data so you're not seeing everything at once and it's more manageable.
You can also leave the Pivot Chart expand/collapse buttons on the chart to allow drilling up/down levels in the data.
See example file attached.
Mynda
June 1, 2018
Offline
Mynda, thanks so much for the reply!
I have learnt a lot through your tutorials!
June 1, 2018
Offline
hello Mynda, can you please show me how to turn the table into the query in the your attached file?
thanks.
July 16, 2010
Offline
Hi Tina,
You don't need to turn the table into a query. I had to do that so I could Pivot your data again because you had pasted it as values. You should be able to recreate the PivotTable and Chart that I did from your original source data.
Mynda
1 Guest(s)
