Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Column and Bar Charts | Charts and Charting in Excel | |||
Column to Charts | Charts and Charting in Excel | |||
Combine Clustered Column Bar charts and Stacked column bar charts | Charts and Charting in Excel | |||
Matching the colors Column Charts and Pie Charts | Charts and Charting in Excel | |||
Column charts with multiple data in each column | Charts and Charting in Excel |