How to create cumulative bar in 100% Stacked Bar graph?

[wes228]

I have a 100% Stacked Bar graph that has a breakdown of ethnicity for an academic program we ran, with one bar for 2012, 2013, 2014, 2015, and 2016 each. After 2016, I would like to have a cumulative bar that shows the breakdown combined for 2012-2016. Is it possible to do this in the same graph, or will I have to create another chart?

Thanks.

[noboffinme]

Hi wes228,

Have a look at the attached.

I've created some random data for several years & added a filed that totals the years together.

Let me know if this suits & if not can you post an example of what your results would look like before & after.

Cheers

[wes228]

Thank you! I appreciate it. So it looks like there is no way to do this with a PivotChart from a PivotTable, it needs to be a regular chart. I guess I can copy and paste the data from my PivotTable and work off that.

Thanks again.

[noboffinme]

You didn't mention that it was a Pivot Chart.

I haven't tried but you should be able to do the same thing.