Line chart with two series; how to add points to one and not the other?
 

Hello,

I have a range of cells from Column A that charts into Series A on a
line chart.

I have a range of cells from Column B that charts into Series B on the
line chart.

Now, I have a range of cells from Column C that I want to use to add
data points to Series B, but they always go into Series A. (I'm using
Select cells, Copy, Paste Special into chart.)

What's the fix? If I move the "C" cells into Column B and then do the
Select-Copy-Paste Special routine that does the trick, but is that all
I can do?

Thanks.