How do I create a graph with 2 lines (on one axis) and columns (on the second axis)?

I am trying to create a graph that has two line series (representing percentages) and one column series (representing numbers). However when I use the built in line/column graph format and then add a third series of % data it make the new series a column not a line.

How can I create my own graph to incorporate two lines and a column series?

Thanks for any help

Brian

Originally Posted by teylyn

Hello Brian,

start with all three series in a line graph.
Then select the line that should be a column and change the chart type to column.

cheers,

Thanks Teylyn...this has been something that has been bugging me for years...and the answer was so simple!!