Help please

I want to plot data from two colum graphs on one axis, one vertically above
the other.
The y axis doesn't need to start at 0 again, just continue on from the one
below.

Anyone know ?

That's a stacked column chart. Select all the data and create a new chart
using this chart type, or take one of the single series charts, copy the
other data, select the chart, and use Paste Special (Edit menu) to add the
data as a new series. Then go to the Chart menu Chart Type, and choose the
stacked column chart type.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"becks" wrote in message
...
Help please

I want to plot data from two colum graphs on one axis, one vertically
above
the other.
The y axis doesn't need to start at 0 again, just continue on from the one
below.

Anyone know ?

Ok probably needed to add more information. I really want to put the
information from both charts on the one axis but seperated.
so theres a normal column graph and the y axis just continues going up then
another group of columns higher with a gap in between them and the ones
below! So there could be another xaxis line there with no labels.
So say the bottom columns go to 20,000 , then the top columns would all
start at 25000.

Do i need to make a stacked column then blank out the the middle stack?

"Jon Peltier" wrote:

That's a stacked column chart. Select all the data and create a new chart
using this chart type, or take one of the single series charts, copy the
other data, select the chart, and use Paste Special (Edit menu) to add the
data as a new series. Then go to the Chart menu Chart Type, and choose the
stacked column chart type.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"becks" wrote in message
...
Help please

I want to plot data from two colum graphs on one axis, one vertically
above
the other.
The y axis doesn't need to start at 0 again, just continue on from the one
below.

Anyone know ?

Do i need to make a stacked column then blank out the the middle stack?

Yep. Not hard, just use =25000-B2 to get the value of the invisible bar.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"becks" wrote in message
...
Ok probably needed to add more information. I really want to put the
information from both charts on the one axis but seperated.
so theres a normal column graph and the y axis just continues going up
then
another group of columns higher with a gap in between them and the ones
below! So there could be another xaxis line there with no labels.
So say the bottom columns go to 20,000 , then the top columns would all
start at 25000.

Do i need to make a stacked column then blank out the the middle stack?

"Jon Peltier" wrote:

That's a stacked column chart. Select all the data and create a new chart
using this chart type, or take one of the single series charts, copy the
other data, select the chart, and use Paste Special (Edit menu) to add
the
data as a new series. Then go to the Chart menu Chart Type, and choose
the
stacked column chart type.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"becks" wrote in message
...
Help please

I want to plot data from two colum graphs on one axis, one vertically
above
the other.
The y axis doesn't need to start at 0 again, just continue on from the
one
below.

Anyone know ?