add a 2nd series to a chart

[Trebor777]

Hi. I have done this myself before with no problem, but for some reason I can't figure it out now.

I have a sheet with dates in column A. I have created a line chart to plot column D against the date, no problem.

I want to add column G to the chart with its values on a second axis. Again I have done this before, but I have forgotten the route (I think I'm getting old).

What's the easiest way please, Excel 2007 here

Thx as always. KK

[MrShorty]

You can
A1) select column G
A2) ctrl-c to copy to clipboard (or your preferred method for invoking the copy command)
A3) select chart
A4) ctrl-v to paste (or your preferred method for invoking the paste command, or use paste special)
A5) Select series -> Format -> plot on secondary axis.

I often prefer to use the Select Data dialog
B1) Select Data
B2) Add series
B3) Select column G for the Values field and OK out of the dialogs.
B4) Select series -> format -> plot on secondary axis.