Thread: Help with bar chart

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

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

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

this is really (on my chart wizard) the center chart in the top row

In C3 enter Plan
in D3 enter Actual
In A2 enter Gift Card
in B2 enter 1/1/2005
in C2 enter = date(2006,6,30)-date(2005,1,1)
In B3 enter 1/1/2005
in D3 enter = date(2006,6,30)-date(2005,1,1)
leave row 4 blank
in A5 enter POS Release
etc down to line 24 where the second line associated with e-Learning Pilot
plot the A1:D24 as bar
(note you may have to go inot the Series portion of the source data section
and set up all of the series the way you want then
Series 1 B2:B24 Label None
Series 2 C2:C24 Lable C1
Series 3 D2:D24 Lable D1
Catagory lable 21:A24

in the chart Select Series one and set line and fill as none and in legend
select series one and clear all
select the lower axis on the chart and in scale for Minimum put 38353
(Date value for 1/1/2005)

Try one of your start values above 1/1/2005 and you will see the floating
bar I mentioned. You could of course do your duration calcs outside the
columns C and D



"D" wrote:

> 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

Thanks again bj!

d3 is Actual or =date(2006,6,30)-date(2005,1,1)

Dan

"bj" wrote:

> this is really (on my chart wizard) the center chart in the top row
>
> In C3 enter Plan
> in D3 enter Actual
> In A2 enter Gift Card
> in B2 enter 1/1/2005
> in C2 enter = date(2006,6,30)-date(2005,1,1)
> In B3 enter 1/1/2005
> in D3 enter = date(2006,6,30)-date(2005,1,1)
> leave row 4 blank
> in A5 enter POS Release
> etc down to line 24 where the second line associated with e-Learning Pilot
> plot the A1:D24 as bar
> (note you may have to go inot the Series portion of the source data section
> and set up all of the series the way you want then
> Series 1 B2:B24 Label None
> Series 2 C2:C24 Lable C1
> Series 3 D2:D24 Lable D1
> Catagory lable 21:A24
>
> in the chart Select Series one and set line and fill as none and in legend
> select series one and clear all
> select the lower axis on the chart and in scale for Minimum put 38353
> (Date value for 1/1/2005)
>
> Try one of your start values above 1/1/2005 and you will see the floating
> bar I mentioned. You could of course do your duration calcs outside the
> columns C and D
>
>
>
> "D" wrote:
>
> > 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