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