2 sets of data on a scatter chart?

I have 2 sets of data which both use the same x-axis...how can i represent both of these sets of data on the same scatter graph so it easier to compare them?

Hope that explains my problem!

Thanks for any help.

Macbook Pro, Mac OS X (10.4.5)

Posted on Dec 7, 2007 5:12 PM

Reply
2 replies

Dec 7, 2007 5:18 PM in response to Archie77

I have just spotted another discussion with a person having a similiar problem, and the result looks like this is not possible. Though if i am wrong please tell me!

If it is true it is not possible, this is poor for apple, as this is a basic and common feature that should have easily been incorporated in numbers...i dont want to have to change back to anything which involves microsoft!

Dec 7, 2007 8:38 PM in response to Archie77

Since each series in a scatter plot is an adjacent x-y column pair, it isn't possible to arrange two series in such a way that the series share an x column but have distinct y columns (you can, for what it is worth, have two series that share a y for one and an x for the other... see below).

That said, this is not hard to work around. Simply introduce a second x column to the left of the second y column. If, for example, the shared x is in column A, fill this this new column with the formula =A which will create a copy of the shared x which can be used to pair with the second y for the second series of the scatter plot.

While on this topic, let me point out a related, I think, non-obvious thing about the series of a plot. In the case of a two series scatterplot, for instance, the two series don't need to be adjacent (the x-y pairs do have to be adjacent, I think). To arrange this, select the two pairs of columns containing the data for the two series. Since they are not contiguous you can use cmd-clicking to make discontiguous selections, then create the scatter plot.

It also is possible to move around the source ranges for each series independently. Here the trick is to select the points in one of the series in an existing plot by clicking on one of its points in the plot. You have done this correctly when you see a circular selection indicator in each of the points in the series. This will also highlight the series' cells in the source table. By grabbing the border of the source cells, this can be dragged around to a new set of cells (or, oddly, even overlapped with the other series).

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

2 sets of data on a scatter chart?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.