Overlay charts in 2007
 

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

Overlay charts in 2007
 

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

Overlay charts in 2007
 

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