December 5, 2016
I have a question about how to create a bar / stacked bar chart in a pivot chart. I'm having problems so i'm sure it has something to do with adding a different series or the way I have my data prepared. I'm not a complete beginner at charts, but don't have a lot of experience either.
Basically I want to compare a quantity of an item that was scheduled to be worked on in the 1st Quarter (Oct - Dec) of 2015 as a single solid bar, and compare that to what was actually worked on. I would like to display what was actually worked on as a stacked bar chart (planned / unplanned) compared to the scheduled solid bar.
I am calling it planned if it was scheduled to be worked on and was actually worked on in that QTR, and unplanned if it was not scheduled to be worked on in that QTR but was worked.
I'd like to figure out the best way to display this data in order to use a pivot chart and slicers.
Basically it would be 2 bars for each QTR in the year. One bar for the plan, and one stacked bar for the execution (planned / unplanned)
I tried to upload an image example, but don't have permissions.
Appreciate any help you can offer!
July 16, 2010
I haven't tested as it's tricky without your data, but I don't think you can create this as a combo Pivot chart. Plus Pivot charts are buggy when you make lots of changes to their default format in that they tend to lose then changes on refresh.
You're better off creating a regular chart from the PivotTable as described here: https://www.myonlinetraininghub.com/creating-excel-charts-from-multiple-pivottables
June 25, 2016
June 25, 2016
See if this is what you are looking for.
Although the data is not from a Pivot Table, you will need to ensure that your chart's source data is arranged like this.
Unless you are able to get the Pivot Table to give you this arrangement, I would suggest you use formulas to extract the data and then create a normal chart from it.
Hope this helps.
Most Users Ever Online: 57
Currently Browsing this Page:
Frans Visser: 157
mey tithveasna: 69
Anders Sehlstedt: 31
Guest Posters: 1
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas