Prev: Plus / Minus Charts?
Next: Showing a different set of data in a chart
From: Christyr on 22 Feb 2010 13:50
Is it possible to overlay a column chart with a line chart in Excel 2007?
It looks as if the horizontal axis has 2 groups of labels and the charts are
using the same vertical axis labels.
thank you for your time,
Christy
From: trip_to_tokyo on 22 Feb 2010 14:04
Yes.

Please look at:-

http://www.pierrefondes.com/

- item number 69 towards the top of my home page where there is a worked
example.

Please hit yes if my comments have helped.

Thanks.



"Christyr" wrote:

> Is it possible to overlay a column chart with a line chart in Excel 2007?
> It looks as if the horizontal axis has 2 groups of labels and the charts are
> using the same vertical axis labels.
> thank you for your time,
> Christy
From: Jon Peltier on 23 Feb 2010 14:14
Make a column chart with all the data, then right click on one series,
choose [Change] Chart Type, and select a line chart type for the
selected series.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/


On 2/22/2010 1:50 PM, Christyr wrote:
> Is it possible to overlay a column chart with a line chart in Excel 2007?
> It looks as if the horizontal axis has 2 groups of labels and the charts are
> using the same vertical axis labels.
> thank you for your time,
> Christy
 | 
Pages: 1
Prev: Plus / Minus Charts?
Next: Showing a different set of data in a chart