View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
Becks Becks is offline
external usenet poster
 
Posts: 13
Default How do i make two column graphs into one? on one axis

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 ?