Hi All,
I'm sure this is a very simple question, although I can't seem to find an answer.
In Excel 2003 how do I create a bar chart with columns overlapping one another?
I have 4 sets of data, with 3 separate figures in each set. I need to put all of this in one bar chart, with the figures for each set overlapping.
For example:
Data Set 1
Figures A 100
Figures B 200
Figures C 300
All these need to be in the same column, but not stacked up. So there will be a column for 100, and behind that one for 200 and one for 300, as opposed to a stacker which would add it all up, and then data set 2 will be the next column and so on.
Any help much appreciated
I'm sure this is a very simple question, although I can't seem to find an answer.
In Excel 2003 how do I create a bar chart with columns overlapping one another?
I have 4 sets of data, with 3 separate figures in each set. I need to put all of this in one bar chart, with the figures for each set overlapping.
For example:
Data Set 1
Figures A 100
Figures B 200
Figures C 300
All these need to be in the same column, but not stacked up. So there will be a column for 100, and behind that one for 200 and one for 300, as opposed to a stacker which would add it all up, and then data set 2 will be the next column and so on.
Any help much appreciated
