User profile for user: Paul Wilke
Paul Wilke Author
User level: Level 1
0 points

Zooming in on data in an existing scatter plot

I have an existing scatter plot in numbers that represents a weight history. It has weight on the Y axis and the date on the X axis. It has several years worth of data. When lookin at the plot, I would like to "zoom in" on a smaller section of the plot so as to better see the data in a small date range and pick off the Y values. Is there a way to zoom in, for instance by drawing a zoom box around the desired data? Or is there a way to easily see the Y values on the plot? Excel allows this by hovering the cursor over a data point and it shows the XY data for that point. Thanks in advance.

Paul

MacBook Air (M2, 2023)

Posted on Mar 2, 2024 9:25 PM

Reply
Question marked as Top-ranking reply
User profile for user: Yellowbox
Yellowbox
User level: Level 7
21,915 points

Posted on Mar 3, 2024 2:40 AM

Hi Paul,


No. Numbers does not have a feature to show XY data when hovering over a point in a scatter plot.

There is a way to zoom in to a scatter plot by hiding the unwanted rows in the source table.


Some made-up data in Table 1. The scatter plot is created from the visible rows in Columns A and B.



Formula in Table 1 C2 is

IF(
OR(
Zoom::A$2="",Zoom::B$2=""),"",
 IF(
AND(A2≥Zoom::A$2,A2≤Zoom::B$2
),
"Show",""
)
)


Now enter Start and End dates into the Zoom table:



Apply a Filter to Table 1:



Have we zoomed in to a relevant part of the scatter plot?


Regards,

Ian.

View in context

Similar questions

3 replies
Question marked as Top-ranking reply
User profile for user: Yellowbox
Yellowbox
User level: Level 7
21,915 points

Mar 3, 2024 2:40 AM in response to Paul Wilke

Hi Paul,


No. Numbers does not have a feature to show XY data when hovering over a point in a scatter plot.

There is a way to zoom in to a scatter plot by hiding the unwanted rows in the source table.


Some made-up data in Table 1. The scatter plot is created from the visible rows in Columns A and B.



Formula in Table 1 C2 is

IF(
OR(
Zoom::A$2="",Zoom::B$2=""),"",
 IF(
AND(A2≥Zoom::A$2,A2≤Zoom::B$2
),
"Show",""
)
)


Now enter Start and End dates into the Zoom table:



Apply a Filter to Table 1:



Have we zoomed in to a relevant part of the scatter plot?


Regards,

Ian.

Reply

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.

Zooming in on data in an existing scatter plot

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