2 sets of stacked data in a column chart

[3G]

Hi there-

I have 2 "major" data categories...projected & actual. Both categories can be further broken down to Business & Technical. What I'm trying to show is Projected Business & Techincal (1 bar) for the month vs Actual Business & Technical (1 bar).


I can get one set of the series to stack (either only projected business & techincal, or, actual business & technical), but, not both NEXT to each other. It keeps stacking them all on top of each other.


Any ides?


Thanks

3G

 

[OleMiss2010]

Can you post a picture of the chart that you are getting?

 

[3G]

I'm not getting a chart...it doesn't seem to work when I pick this combo of data. I can get it for say, projected only, or, actual only...just not BOTH on the same graph.

 

[Luke M]

3G,

Data layout is the key. Perhaps Jon's article here will help:

http://peltiertech.com/WordPress/clustered-stacked-column-bar-charts/

 

[OleMiss2010]

This is interesting. I'm assuming that you have two series (one for business and one for technical) and then two x axis values (Projected and Actual). Is that correct?

 

[3G]

Thanks @Luke!!! As always you're help is appreciated...


Hi OleMiss, yes. Luke's article link pointed out a key flaw with my data organization.