Second Vertical axis problem

[Maki12]

Well,my problem is that i can't plot 3 data series in two vertical axis...I want to plot the first two data series on the primary axis and the third at the secondary axis at a line chart...Can anybody help?

[MrShorty]

Can I assume you are following these instructions to add the secondary axis? http://office.microsoft.com/en-us/ex...165.aspx?CTT=1

[newdoverman]

Create a chart with all three data series. Click on the third data series in the chart to select it. Then, on the Layout tab, Current Selection, Format Selection. Click on Secondary Axis. A secondary axis should be inserted on the right side of the chart for the third series that you previously chose.

You can now click on the Axis Button in the Axis Group and choose options for that axis. For more detailed options click on More Secondary, Vertical Axis options at the bottom of the dialogue box.

It might be a good idea to have this third data series plotted with a different chart type to make it stand out from the other two.