Need help to plot a graph

[vijehspaul]

Hi all,

In my office there are a lot of projects running almost in parallel.

I would like to plot their status date by date on a graph so that the one who view should get ,

project length

project completion status,


I have an image got from a webpage, looks like the the graph what i am looking for.

please see: https://picasaweb.google.com/105861858295091185372/November22012?authkey=Gv1sRgCJiU5cjDz_WsZA#5806092376865690562


In this pic assume, Y axis is Name of projects. X axis have both date and project completion status ( done/remaining )


is it possible to plot a graph of this kind in excel ?

 

[Faseeh]

Hi vijesh,


Yes it is possible, there are two options:


1. Take up a gantt chart, plot every activity twice, first one showing 100% mark and second one showing actual progress. (100% may show actual days or if using dates then planned start and end date to show a full bar, second one showing days passed or start to present date to show partial bar)


2. Make a simple bar chart with two bar, set the overlap value for both series to 100%, make 100% bar transparent with borders visible and you are done.


Regards,

Faseeh