Help on Stacked column graph

[Alvaro]

Hi,

with the following group of data
1 2 3 4
a 10 10 30 5
b 30 5 32 42
c 10 12 15 28

I want to have a graph with 2 column s for each letter, one with the value
of column 1 and another one with the sum of columns 2, 3 & 4 with different
color for each value.
I've seen that is possible in some built in graph but not sure how to make it

Thanks

 

[smartin]

Hi,

with the following group of data
1 2 3 4
a 10 10 30 5
b 30 5 32 42
c 10 12 15 28

I want to have a graph with 2 column s for each letter, one with the value
of column 1 and another one with the sum of columns 2, 3 & 4 with different
color for each value.
I've seen that is possible in some built in graph but not sure how to make it

Thanks

Hi Alvaro, You can do this as follows:

Add an additional series "5" with some non-zero dummy values (this just
makes the series easier to edit later)
Create a stacked column chart with series in columns
Move series 1 and 5 to the secondary y-axis and make sure they are
changed to a regular column chart
Delete the secondary y-axis
Decrease the overlap of series 1 to -100
Set the values for series 5 to 0
Increase the gap width of series 2 to suit
Delete the appearance of series 5 in the legend (if you are using a legend)

You may find it is easier to adjust the spacing of the columns by adding
a 6th dummy series and treating it as you did series 5.