ExcelBanter - Column Charts

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Column Charts (https://www.excelbanter.com/excel-programming/408245-column-charts.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

Try using a Stacked Column Chart. You may have to rearrange your data a
little; try different groups or categories. Try doing some simple math, like
each is a percentage of 100%

Regards,
Ryan--

--
RyGuy

"Beep Beep" wrote:

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