View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default How do i make two column graphs into one? on one axis

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 ?