how does one plot a line-column on two axes in excel?

G

gbrunnhoeffer

How does one use Excel 2007 to plot a line and a bar graph with two axes -
the same chhart offered in Excel 2003 under Custom Types?
 
A

Andy Pope

Hi,

You have to build the combination chart yourself.
Create a column chart based on both data sets. Select the column you want as
a line and use Change Chart Type to set it to line chart.

Cheers
Andy
 
Top