Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
Stacked Column Chart
I seem to be having the hardest time in the world completing this chart! I
hope someone can help.. Here's what I'm trying to do: I have a row titled Total amount, then four other rows above it, (for discussion sake we'll say they are A, B, C, D) the column next to those titles has the values. In "A", I've got the number 0 In "B", I've got the number 24 In "C", I've got the number 9 In "D", I've got the number 8 For "Total", I've got 41 I need to show a stacked column chart whe "Total" is it's own bar. "A", "B", "C", "D" are stacked. How do I go about doing this? |
#2
|
|||
|
|||
Stacy -
Stagger your data in two adjacent columns: ABCD Total A 0 B 24 C 9 D 8 Total 41 Select all of this data, and construct a stacked column chart, with series in rows. In the first position, A through D are stacked up, and Total doesn't appear, because it is blank (zero value). In the second position, only Total shows up because it's the only non-zero value. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Stacy wrote: I seem to be having the hardest time in the world completing this chart! I hope someone can help.. Here's what I'm trying to do: I have a row titled Total amount, then four other rows above it, (for discussion sake we'll say they are A, B, C, D) the column next to those titles has the values. In "A", I've got the number 0 In "B", I've got the number 24 In "C", I've got the number 9 In "D", I've got the number 8 For "Total", I've got 41 I need to show a stacked column chart whe "Total" is it's own bar. "A", "B", "C", "D" are stacked. How do I go about doing this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Column Chart Question | Excel Worksheet Functions | |||
combination clustered column and stacked bar chart | Charts and Charting in Excel | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
Stacked column and column combo chart | Charts and Charting in Excel | |||
Making Special "Stacked Column" Chart | Charts and Charting in Excel |