Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 101
Default Column Charts

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   Report Post  
Posted to microsoft.public.excel.programming
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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Column and Bar Charts PA Charts and Charting in Excel 5 January 8th 08 02:41 PM
Column to Charts Willyb Charts and Charting in Excel 0 October 28th 06 06:04 PM
Combine Clustered Column Bar charts and Stacked column bar charts Richard Charts and Charting in Excel 1 October 26th 06 02:44 AM
Matching the colors Column Charts and Pie Charts RohanSewgobind Charts and Charting in Excel 3 April 21st 06 09:35 PM
Column charts with multiple data in each column steve root Charts and Charting in Excel 1 June 22nd 05 05:16 PM


All times are GMT +1. The time now is 10:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"