Is there a way to create multiple groups of stacked bar charts in.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I haven't been able to find a way to create a chart in either PowerPoint or
Excel that shows multiple stacked bars that compares trend data for a number
of years, for example, for three different items, between two major groups.
I basically have 3 columns of data (i.e., 3 years), 3 items and two major
providers.

Example

provider 1 service #1 datapoint #1 datapoint #2 datapoint #3
service #2 datapoint #4 datapoint #5
datapoint #6
service #3 datapoint #7 datapoint #8
datapoint #9

then the same thing again for provider 2.

I want to generate a chart that has a stacked bar so that provider 1 shows
the three datapoints for service #1, #2 & #3 as three stacked bars and then
have provider #2 right next to each bar with its datapoints.

I've yet to find a way to do this. Has anyone been able to do so?
 
set up your stacked chart

set your data like this


P1/Svc1 P2/Svc1 Empty Column P1/Svc2 P2/Svc2
East 20.4 90 0 20.4
100
West 30.6 34.6 0 31.6 50
North 45.9 45 0 43.9
10

Of course, don't put a title on the empty column column

Right-click one of the stacks and format data series
on the last tab, overlap=100, gap width=0

Is that what you're after?
 
Back
Top