LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default Gantt chart - fill show progress of tasks over task time period???

as per title...

basically want to be able to show progress on a gantt chart...
so lets say you have a job that you plan to take from 01.09.06 'till 14.09.06
you also want to see progress over this time period to monitor if it's on
track or not
so I would see this being able to be displayed by filling a merged cell
(that spanned the desired time period) the more progress made the more of the
cell would be filled in.

as per that scenario... on about 07.09.06 the cell would be half filled
showing you was dead on track.

or maybe there's another way to do the same thing

I will doctor a jpeg to show what I mean (see below)
You see tasks number 1, 2 and 3 span dates from 1.9.06 till 10.9.06 so take
up the same amount of space on the gantt chart but they are at differant
stages of completion so the cells reflect this in the amount they are filled.
http://img145.imageshack.us/img145/97/cellsru3.jpg

 
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
Plotting Bands for Task Overlaps gtslabs Charts and Charting in Excel 1 December 5th 05 01:38 AM
Time and motion chart deant Charts and Charting in Excel 0 September 21st 05 08:22 AM
Gantt chart Aloysicus Charts and Charting in Excel 1 August 6th 05 11:32 PM
Timeline Chart? ckrogers Charts and Charting in Excel 3 March 17th 05 09:20 PM
unmet challenge boris Excel Worksheet Functions 2 March 16th 05 02:13 PM


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