Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pie chart on a pie chart (exploded)? | Excel Discussion (Misc queries) | |||
Urgent Chart Assistance | Charts and Charting in Excel | |||
Urgent Chart Questions | Excel Discussion (Misc queries) | |||
Urgent Chart Assistance Requested | Excel Discussion (Misc queries) | |||
Scrollbar on Chart Jumps to Left when Chart is Clicked | Charts and Charting in Excel |