A
Anna Krieger
Could anyone help?
I want to create a bar graph that compares 4 sets of
data. Basically I want to have two different "Stacked
columns" next to each other... I think the proper
terminology is that I'm trying to make a "cluster" graph
of two "stacked columns"
I want to get one bar with two sets of data in it stacked
on top of one another. Then, next to the first bar of two
sets of data, I'd like to get another bar also with two
different sets of data stacked together.
EX: if the data sets were as follows...
a= 2
b= 4
x= 10
y= 5
Then I'd have one bar that was 6 units total, but with 2
units in one color and 4 in another.
next to this, there would be another bar totalling 15
units, with 10 units one color and 5 units another color
within the bar.
I can get this to work for comparing 2 types of data [by
going to "chart types", clicking on "columns" and then
selecting the second option--"stacked column."] but I
can't find a way to do it for 4 units of data.
Can anyone help, i'd greatly appreciate it...
I just can't seem to figure out how to actually make a
custom chart.
Thanks so much, all.
AK
I want to create a bar graph that compares 4 sets of
data. Basically I want to have two different "Stacked
columns" next to each other... I think the proper
terminology is that I'm trying to make a "cluster" graph
of two "stacked columns"
I want to get one bar with two sets of data in it stacked
on top of one another. Then, next to the first bar of two
sets of data, I'd like to get another bar also with two
different sets of data stacked together.
EX: if the data sets were as follows...
a= 2
b= 4
x= 10
y= 5
Then I'd have one bar that was 6 units total, but with 2
units in one color and 4 in another.
next to this, there would be another bar totalling 15
units, with 10 units one color and 5 units another color
within the bar.
I can get this to work for comparing 2 types of data [by
going to "chart types", clicking on "columns" and then
selecting the second option--"stacked column."] but I
can't find a way to do it for 4 units of data.
Can anyone help, i'd greatly appreciate it...
I just can't seem to figure out how to actually make a
custom chart.
Thanks so much, all.
AK