Graphs (Excel 2007)

Topic

New Reply

I have been using Excel 2000 and things are laid out differently in 2007. I would like to create a line graph with a column on 2 Axes. Can someone, in simple terms, tell me how I locate that?

Reply | Quote

Replies

Have a look at http://www.peltiertech.com[/url%5D maybe Jon has written something about doing this in 2007.

Reply | Quote

This is a great site. Thanks!

Reply | Quote

You have to do it manually, I think. Create a line chart using both series. Select the series you want to be a column, right-click, choose ‘Change series chart type’ and select a column type. Then right-click again, choose ‘Format data series’ and choose Secondary axis.
HTH

Reply | Quote

That works! Thanks.

Reply | Quote