How do i make two column graphs into one? on one axis

[becks]

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 ?

 

[Jon Peltier]

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

 

[becks]

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]

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