Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Graph bars are sticking
I created a graph (3 records data from April-03 to Mar-09) with chart type
bars but output graph looks like the bars are stacking. Can any one suggest me what needs to be done to see if the bars will line up beside each other (not supposed to be stacked bars) Note: I am using office-2003 Advanced Thanks, Vinod |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Graph bars are sticking
Right click on the chart, choose Chart Type from the context menu, and
change to a clustered column type. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Vinod" wrote in message ... I created a graph (3 records data from April-03 to Mar-09) with chart type bars but output graph looks like the bars are stacking. Can any one suggest me what needs to be done to see if the bars will line up beside each other (not supposed to be stacked bars) Note: I am using office-2003 Advanced Thanks, Vinod |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Graph bars are sticking
Thanks for immediate response.
But it is already in clustered column type. ie., Top most left one. Suggest me how can move further "Jon Peltier" wrote: Right click on the chart, choose Chart Type from the context menu, and change to a clustered column type. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Vinod" wrote in message ... I created a graph (3 records data from April-03 to Mar-09) with chart type bars but output graph looks like the bars are stacking. Can any one suggest me what needs to be done to see if the bars will line up beside each other (not supposed to be stacked bars) Note: I am using office-2003 Advanced Thanks, Vinod |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Graph bars are sticking
Then how is it "stacking"? Did you change the overlap to 100?
- Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Vinod" wrote in message ... Thanks for immediate response. But it is already in clustered column type. ie., Top most left one. Suggest me how can move further "Jon Peltier" wrote: Right click on the chart, choose Chart Type from the context menu, and change to a clustered column type. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Vinod" wrote in message ... I created a graph (3 records data from April-03 to Mar-09) with chart type bars but output graph looks like the bars are stacking. Can any one suggest me what needs to be done to see if the bars will line up beside each other (not supposed to be stacked bars) Note: I am using office-2003 Advanced Thanks, Vinod |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Graph bars are sticking
Overlap is 0(zero) and Gapa Width is 350.
"Jon Peltier" wrote: Then how is it "stacking"? Did you change the overlap to 100? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Vinod" wrote in message ... Thanks for immediate response. But it is already in clustered column type. ie., Top most left one. Suggest me how can move further "Jon Peltier" wrote: Right click on the chart, choose Chart Type from the context menu, and change to a clustered column type. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Vinod" wrote in message ... I created a graph (3 records data from April-03 to Mar-09) with chart type bars but output graph looks like the bars are stacking. Can any one suggest me what needs to be done to see if the bars will line up beside each other (not supposed to be stacked bars) Note: I am using office-2003 Advanced Thanks, Vinod |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Graph bars are sticking
All your series on the primary axis?
- Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Vinod" wrote in message ... Overlap is 0(zero) and Gapa Width is 350. "Jon Peltier" wrote: Then how is it "stacking"? Did you change the overlap to 100? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Vinod" wrote in message ... Thanks for immediate response. But it is already in clustered column type. ie., Top most left one. Suggest me how can move further "Jon Peltier" wrote: Right click on the chart, choose Chart Type from the context menu, and change to a clustered column type. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Vinod" wrote in message ... I created a graph (3 records data from April-03 to Mar-09) with chart type bars but output graph looks like the bars are stacking. Can any one suggest me what needs to be done to see if the bars will line up beside each other (not supposed to be stacked bars) Note: I am using office-2003 Advanced Thanks, Vinod |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Graph bars are sticking
To answer your question "Yes" it all are on primary axis.
"Jon Peltier" wrote: All your series on the primary axis? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Vinod" wrote in message ... Overlap is 0(zero) and Gapa Width is 350. "Jon Peltier" wrote: Then how is it "stacking"? Did you change the overlap to 100? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Vinod" wrote in message ... Thanks for immediate response. But it is already in clustered column type. ie., Top most left one. Suggest me how can move further "Jon Peltier" wrote: Right click on the chart, choose Chart Type from the context menu, and change to a clustered column type. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Vinod" wrote in message ... I created a graph (3 records data from April-03 to Mar-09) with chart type bars but output graph looks like the bars are stacking. Can any one suggest me what needs to be done to see if the bars will line up beside each other (not supposed to be stacked bars) Note: I am using office-2003 Advanced Thanks, Vinod |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Re-size Bars in Bar Graph | Charts and Charting in Excel | |||
Sort bars in a graph | Excel Discussion (Misc queries) | |||
How do I graph 2 bars with 2 different axes? | Charts and Charting in Excel | |||
How can I change a graph with 2 bars,2 lines to 3 bars, 1 line? | Charts and Charting in Excel | |||
How do I change bars into just lines on a bar graph? | Charts and Charting in Excel |