LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
BL
 
Posts: n/a
Default Distribution Chart

Dear all,

I would like to have your help in designing the following chart. Basically,
the chart should display the number of task in each time frame. I would like
to have Y axis showing the time frame. Assuming I have grouped the tasks into
3 categories and the data is as follows :

Start End Revised End # of Task
1 1/1/05 12/31/05 N/A 18
2 3/1/05 12/31/05 N/A 16
3 4/1/05 6/30/05 7/30/05 12

So there will be 3 horizontal bars, Bar 1 is the longest (Jan - Dec) and at
the end of the bars, 18 will be displayed. Bar 2 will start at Mar and end
in Dec with 16 at the end; bar 3 will start at Apr and end at Jun with 12 at
the end.

Basically, the chart is to display how many task in each period. Any
suggestion how I can draw the chart. If you have any better idea to present
the data, please let me know. Thank you.

BL
 
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
Chart Help Please Alex Excel Discussion (Misc queries) 2 April 8th 05 06:57 PM
Timeline Chart? ckrogers Charts and Charting in Excel 3 March 17th 05 09:20 PM
how do i draw a distribution chart in excel travish19 Charts and Charting in Excel 3 January 15th 05 01:18 AM
Problem with xlusrgal.xls file Alfred S C Lee Charts and Charting in Excel 2 December 29th 04 05:54 PM
pivot table multi line chart souris Charts and Charting in Excel 2 December 7th 04 03:56 AM


All times are GMT +1. The time now is 01:18 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"