Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Chart Help Please | Excel Discussion (Misc queries) | |||
Timeline Chart? | Charts and Charting in Excel | |||
how do i draw a distribution chart in excel | Charts and Charting in Excel | |||
Problem with xlusrgal.xls file | Charts and Charting in Excel | |||
pivot table multi line chart | Charts and Charting in Excel |