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

C

chowgirl

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top