Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Help on Stacked column graph
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 -- Alvaro |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Help on Stacked column graph
Alvaro wrote:
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stacked column graph | Charts and Charting in Excel | |||
Stacked column graph | Charts and Charting in Excel | |||
Creating a graph similar to a stacked column graph | Charts and Charting in Excel | |||
How do you combine a stacked column and single column graph? | Charts and Charting in Excel | |||
How to mix a stacked column and a clustered one on same graph? | Charts and Charting in Excel |