Progress bar in chart

Hello,

I have a table with this data. I would like to create a chart for each "group" where for each project I would like to have a progress bar (in green) according to the dates evolution. "Date 4" should be inferior to "Limit DT" if not the bar should become Red. In the same way if there is no "Date 4" the bar should be red again and the "Limit DT" should be compared to the current date. The difference between dates (and so the progress bar, too) should be calculated in days.

Is there any easy way to do something like this?

thanks for any help

Georgios

Hi oldchippy,

it looks like what I need. Is it possible to present it in a separate chart with a bar for the whole process, I mean from the first date to the last (date4 or today when project is not finished yet)? Each achieved step should be in green (the not achieved or out of limit DT in red)?

thanks

Originally Posted by Georgios

Hello,

I have a table with this data. I would like to create a chart for each "group" where for each project I would like to have a progress bar (in green) according to the dates evolution. "Date 4" should be inferior to "Limit DT" if not the bar should become Red. In the same way if there is no "Date 4" the bar should be red again and the "Limit DT" should be compared to the current date. The difference between dates (and so the progress bar, too) should be calculated in days.

Is there any easy way to do something like this?

thanks for any help

Georgios

Georios:

Here's a link to a simple progress chart that might help. It includes both a how-to and a downloadable Excel workbook.

Kelly