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

G

Guest

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 1
X-Axis Appearing in Plot Area 2
Column-Column on 2 axes 2
colum graph on 2 axes 2
How do I plot a line chart in 3 dimensions (x,y,z)? 1
combination charts: two variables in one series? 1
graph column line graph with two axes 1
pareto chart in Excel 2007? 1

Top