I have the following data:
I would like to have a clustered stack for each month, Jan, Feb, Mar. There would be one stack for High, Medium, Low for each month. The Legend would have "<=14", "<=30" and ">30"
How do I organize my data to create such a chart? Any help would be greatly appreciated!!
Steve
| Excel Workbook | ||||||
|---|---|---|---|---|---|---|
| A | B | C | D | |||
| 1 | January | High | Medium | Low | ||
| 2 | 1 | 6 | 2 | |||
| 3 | 2 | 2 | 3 | |||
| 4 | >30 | 0 | 1 | 4 | ||
| 5 | ||||||
| 6 | February | High | Medium | Low | ||
| 7 | 2 | 3 | 6 | |||
| 8 | 1 | 2 | 2 | |||
| 9 | >30 | 1 | 2 | 1 | ||
| 10 | ||||||
| 11 | March | High | Medium | Low | ||
| 12 | 3 | 4 | 1 | |||
| 13 | 0 | 2 | 1 | |||
| 14 | >30 | 0 | 1 | 3 | ||
Sheet1 | ||||||
I would like to have a clustered stack for each month, Jan, Feb, Mar. There would be one stack for High, Medium, Low for each month. The Legend would have "<=14", "<=30" and ">30"
How do I organize my data to create such a chart? Any help would be greatly appreciated!!
Steve
