Thread: Column Charts
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
ryguy7272 ryguy7272 is offline
external usenet poster
 
Posts: 2,836
Default Column Charts

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