Home |
Search |
Today's Posts |
#1
|
|||
|
|||
split bar chart
I need to create a bar chart using the following data:
Column1 = 2 (value inside cell) Column2 = 3 (value inside cell) Coumn3 = 5 (=column1 + column2) Here's the layout I'm looking for: bar1 would start at 0(zero) and stop at 2 bar2 would start at 3 and stop at 5 (nothing would show below 3 for this bar) It's pretty much a stacked bar graph but each "stack" would be in its own column. Thanks! |
#2
|
|||
|
|||
Not sure if it is what you need but goto
www.stfx.ca/people/bliengme/ExcelTips and look at Column Chart with a Difference best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "maxtrixx" wrote in message ... I need to create a bar chart using the following data: Column1 = 2 (value inside cell) Column2 = 3 (value inside cell) Coumn3 = 5 (=column1 + column2) Here's the layout I'm looking for: bar1 would start at 0(zero) and stop at 2 bar2 would start at 3 and stop at 5 (nothing would show below 3 for this bar) It's pretty much a stacked bar graph but each "stack" would be in its own column. Thanks! |
#3
|
|||
|
|||
I'm actually trying to make a stacked graph to display the stacks as floating
bars, each stack in its own colum. I'm not sure if I can explain it without visual. "Bernard Liengme" wrote: Not sure if it is what you need but goto www.stfx.ca/people/bliengme/ExcelTips and look at Column Chart with a Difference best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "maxtrixx" wrote in message ... I need to create a bar chart using the following data: Column1 = 2 (value inside cell) Column2 = 3 (value inside cell) Coumn3 = 5 (=column1 + column2) Here's the layout I'm looking for: bar1 would start at 0(zero) and stop at 2 bar2 would start at 3 and stop at 5 (nothing would show below 3 for this bar) It's pretty much a stacked bar graph but each "stack" would be in its own column. Thanks! |
#4
|
|||
|
|||
Try a Google for "Excel" + "Gantt"
-- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "maxtrixx" wrote in message ... I'm actually trying to make a stacked graph to display the stacks as floating bars, each stack in its own colum. I'm not sure if I can explain it without visual. "Bernard Liengme" wrote: Not sure if it is what you need but goto www.stfx.ca/people/bliengme/ExcelTips and look at Column Chart with a Difference best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "maxtrixx" wrote in message ... I need to create a bar chart using the following data: Column1 = 2 (value inside cell) Column2 = 3 (value inside cell) Coumn3 = 5 (=column1 + column2) Here's the layout I'm looking for: bar1 would start at 0(zero) and stop at 2 bar2 would start at 3 and stop at 5 (nothing would show below 3 for this bar) It's pretty much a stacked bar graph but each "stack" would be in its own column. Thanks! |
#5
|
|||
|
|||
I found what I was looking for under Format Data Series Options.
All I needed to do was create a stacked bar chart and make the overlap option = 0. Thanks anyways! "Bernard Liengme" wrote: Try a Google for "Excel" + "Gantt" -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "maxtrixx" wrote in message ... I'm actually trying to make a stacked graph to display the stacks as floating bars, each stack in its own colum. I'm not sure if I can explain it without visual. "Bernard Liengme" wrote: Not sure if it is what you need but goto www.stfx.ca/people/bliengme/ExcelTips and look at Column Chart with a Difference best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "maxtrixx" wrote in message ... I need to create a bar chart using the following data: Column1 = 2 (value inside cell) Column2 = 3 (value inside cell) Coumn3 = 5 (=column1 + column2) Here's the layout I'm looking for: bar1 would start at 0(zero) and stop at 2 bar2 would start at 3 and stop at 5 (nothing would show below 3 for this bar) It's pretty much a stacked bar graph but each "stack" would be in its own column. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Urgent Chart Assistance | Charts and Charting in Excel | |||
Urgent Chart Questions | Excel Discussion (Misc queries) | |||
Urgent Chart Assistance Requested | Excel Discussion (Misc queries) | |||
How do I split the y-axis scale on a chart? | Charts and Charting in Excel | |||
How do you split the Y-axis on an Excel chart? | Charts and Charting in Excel |