Line Graph: Multiple Lines

[mouse88]

Im looking to create a line graph to show three sets of data each on a seperate line.

The first two data types are numbers and the third is a percentage.

How can I get the data to show correctly on one chart? Im not interested in the values of each point im only interested on how the line changes.

Heres what I currently have but the percentage line sits at the bottom. Is my only option to have a seperate chart for the percentage?

 

[S M C]

No you don't need a separate chart for that. Right-click on the percentage series, and from the context menu, when you select Format Data Series.. you will get an option to switch the series to a secondary axis.

 

[Weaver]

Im looking to create a line graph to show three sets of data each on a seperate line.

The first two data types are numbers and the third is a percentage.

How can I get the data to show correctly on one chart? Im not interested in the values of each point im only interested on how the line changes.

Heres what I currently have but the percentage line sits at the bottom. Is my only option to have a seperate chart for the percentage?

It's possible to attach your second dataset to a secondary axis. If you select it in the graph, and right click, you ought to be able to achieve this from the menu which appears. Select 'format data series' and there should be 2 radio buttons for primary axis and secondary axis.