Hi Bj:

Thanks! I want the first bar chart from the standard types-bar charts; can
you please post an example of the data source; I think this is the probelm;
and besides the starting point ( intersection of axex X and Y) is comming
2004 and in fact is 2005?

Thanks,

Dan

"bj" wrote:

I am not sure what you mean by "right bar chart"
do you want something like a floating bar chart where there is nothing until
the Start date with a Bar to the end date?
In this case with two lines one for actual and one for plan.

to do this set up your data with two rows for each catagorty and a row
between catagories put rour catagory in for example column A just in the
first row with each set
in the next column enter the start date first for plan and then for Actual
for each catagory
in the next column calculate the duration for each plan and in a 4th column
calculate the duration for actual.
Plot these four columns A as catagory and B, C and D as data in a stacked
barchart.
select the first series on the chart and set the line and fill to none.
for mat the chart as you want it.

"D" wrote:

Hi:

How do I do a right bar chart using the below table; I cannot get itt right...

Project Start Date End Date
Plan Actual Plan Actual
Gift Card 1/1/2005 1/1/2005 6/30/2006 6/30/2006
POS Release 19 1/1/2005 1/1/2005 6/30/2006 6/30/2006
e-Learning Pilot 1/1/2005 1/1/2005 6/30/2006 6/30/2006
POS Release 20 1/1/2005 1/1/2005 6/30/2006 6/30/2006
Central File Maintenance 1/1/2005 1/1/2005 6/30/2006 6/30/2006
i-Debit Cash Back 1/1/2005 1/1/2005 6/30/2006 6/30/2006
Canacomp Gateway Solution 1/1/2005 1/1/2005 6/30/2006 6/30/2006
e-Learning Pilot 1/1/2005 1/1/2005 6/30/2006 6/30/2006


Thanks fro the help,

Dan