PC Review


Reply
Thread Tools Rate Thread

Column Charts

 
 
Beep Beep
Guest
Posts: n/a
 
      24th Mar 2008
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 With Quote
 
 
 
 
ryguy7272
Guest
Posts: n/a
 
      24th Mar 2008
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 With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Combine Clustered Column Bar charts and Stacked column bar charts =?Utf-8?B?UmljaGFyZA==?= Microsoft Excel Charting 1 26th Oct 2006 02:44 AM
Matching the colors Column Charts and Pie Charts RohanSewgobind Microsoft Excel Charting 3 21st Apr 2006 09:35 PM
Column charts with multiple data in each column =?Utf-8?B?c3RldmUgcm9vdA==?= Microsoft Excel Charting 1 22nd Jun 2005 05:16 PM
Re: How to combine Clustered Column and Stacked Column charts in excel Tushar Mehta Microsoft Excel Charting 0 22nd Sep 2004 10:13 PM
How to combine Clustered Column and Stacked Column charts in excel =?Utf-8?B?UmFtdSBSYXlhcHVkaQ==?= Microsoft Excel Charting 0 22nd Sep 2004 09:17 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:38 AM.