Charting multiple multiples

  • Thread starter Thread starter SouthernAZ
  • Start date Start date
S

SouthernAZ

Hopefully I can explain this in a way that will be
understood. Data:

Place A Place B Place C
FWD Back FWD BACK FWD Back
Org_1 1 2 3 2 1 3
Org_2 2 5 4 6 1 4

I would like to place the data so that FWD and Back data is
stacked on top of each other in different colors, and
placed in one row on a 3-D chart as Org-1 and a second row
as Org_2.

Any ideas?

Thanks.
 
If you arrange your data like this:

Back FWD
Org_1 Place A 2 1
Place B 2 3
Place C 3 1
Org_2 Place A 5 2
Place B 6 4
Place C 4 1

you can create a stacked column chart as you described.
 
Back
Top