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

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

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

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

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

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

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