ExcelBanter - Multiple Bars

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Multiple Bars (https://www.excelbanter.com/excel-discussion-misc-queries/181113-multiple-bars.html)

I have some charts using the data below. I want to have one column showing
four (4) colors on top of each other for critical; high; medium and low. Can
do

Jun-07 Critical High Medium Low Unknown TOTAL CRs Created TOTAL CRs Closed
6800 97 124 26 5 0 252 216
7500 112 118 48 2 0 280 255
7600 0 1 0 0 0 1 1
7200 79 90 26 10 0 205 218
7200A 14 12 8 1 0 35 40

Did you try a stacked column chart?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______

"Beep Beep" wrote in message
...
I have some charts using the data below. I want to have one column showing
four (4) colors on top of each other for critical; high; medium and low.
Can
do

Jun-07 Critical High Medium Low Unknown TOTAL CRs Created TOTAL CRs Closed
6800 97 124 26 5 0 252 216
7500 112 118 48 2 0 280 255
7600 0 1 0 0 0 1 1
7200 79 90 26 10 0 205 218
7200A 14 12 8 1 0 35 40