Register
Log In
Unanswered
Home
New Member
Dashboards
December 5, 2016
Offline
Hi,
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!
Mike
See Answer
July 16, 2010
Offline
Hi Mike,
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
Kind regards,
Mynda
Dashboards
June 25, 2016
Offline
Hi Mike
To further add to Mynda's reply, the combo chart you wanted (a stacked bar next to a normal bar) will require that the chart's data source be arranged in a special way. Pivot Table will not be able to do that.
Sunny
Dashboards
June 25, 2016
Offline
Hi Mike
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.
Sunny
Answers Post
Most Users Ever Online: 57
Currently Online:
17 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
sugi gunawan
janja mesec
John DiMartino
lizette acosta
eric johnson
Kim Bond
Nichelle Stevens
Manuel Rodriguez
peter wang
Amit Kanekar
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
