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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Plotting x-y data to same physical dimension on plot 2
X-Axis Appearing in Plot Area 2
graph column line graph with two axes 1
How to change series plotting order without changing legend order? 6
Column-Column on 2 axes 2
Odd chart type needed 1
Mixing scatter plot with a category plot 2
reverse axis not working as before... 0

Top