How do I change column into lines on a Line-Column chart?

K

Ken

I want to create a chart with three columns and one line using two axis. Any
help would be useful.

Thanks
 
A

Andy Pope

Hi Ken,

Create a column chart based on all your data. Select the series that you
want as line and right click it. Choose Chart Type and change it to
Line. Now double click the new line so you can change the Axis value to
secondary.

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

simple chart 0
How to create a bubble chart with more than 2 variables. 0
Filtered view of Visio Chart 0
Autonumber field in Excel that behaves the same as Access 0
column charts with set set of data 0
MS Project Center-Autolink column fields 0
Two lines in one in one line - How to do 2
Labeling on independently stacked line chart 0

Top