Add data series to scatter chart

Question

Level 1

0 points

Add data series to scatter chart

I feel a fool, but cannot figure out how to add an additional data series to my scatter plot. Basically, I want everything in column A numbered "1" to be a single data series (easy enough to do), but want everything in column A numbered "2" as the next data series. Column B is my X-axis data, column C is my Y-axis data.

I have unticked the "Share X values". If the data is in different tables, numbers automatically creates a new data series. However my data is all in the same table (and over 4000 rows, so I don't want to move the data into separate tables). Any ideas?

Much gratitude. Jes.

Posted on Jun 1, 2015 10:39 PM

Reply

Answer 1

Best reply

Yellowbox

Level 7

20,383 points

Jun 2, 2015 12:34 AM in response to jeshill

Hi Jes,

The only way I can get this to work is to create another table. But no need to Cut and paste your data. Formulas will do the work.

In the new table (Data for Scatter Plot) Column A is the same as Original Data. I did copy and paste, but you could use a formula in A2 (and Fill Down)

=Original Data::A2

Series numbers go in pairs across Row 1 (to form X1, Y1, X2, Y2 etc.)

Formula in B2 (and Fill Down)

=IF(Original Data::$A2=B$1,Original Data::$B2,"")

Formulas in C2 (and Fill Down)

=IF(Original Data::$A2=C$1,Original Data::$C2,"")

Now (fingers crossed that I got the $ signs correct in the formulas) you can select B and C and Fill Right

Turn off Share X values.

Regards,

Ian.

Reply

Answer 2

jeshill Author

Level 1

0 points

Jun 2, 2015 4:32 PM in response to Yellowbox

Thanks Ian. A functional work around, though a bit strange that we can't add new data series anymore! I'll give it a go. Cheers, Jes.

Reply