Highlight a Chart Value

Am I missing something (like using the Option key, or Alt key)...

If I hover my cursor over a point in a chart, I would expect to see the X and Y coordinates of the value in a floating text box.


This is not happening in Number Version 3.5.2.

iMac with Retina 5K display, OS X Yosemite (10.10.2), Airport Extreme, LinkSys NAS200, RDC to Sony PCG XE17

Posted on Feb 19, 2015 7:09 PM

Reply
8 replies

Feb 20, 2015 6:49 PM in response to Wayne Contello

Wayne,

Thanks, I am aware, but it is messy, especially if the chart has 100's of closely placed points in the graph.

I was expecting such a basic functionality, having been a serious Excel user for many years.

User uploaded file

Ii takes many clicks and associated navigation around the Sheet to get this in Numbers, which looks OK in this small screen selection, but the chart looks "absolutely rubbish" with numbers attached to the whole plot.


User uploaded file

Incidentally...

I exported this project to Excel, and was stunned to see just how accurate, and easy and complete the project turned out.

Mar 13, 2015 6:46 PM in response to t quinn

Thanks Quinn...

Am really getting to like Numbers versus Excel. Its a learning curve, but a very rewarding experience, once features and functionality is discovered, driven by the requirements of a particular application...


As I said, things I miss so far are:

a) Goal Seeking,

b) Macros, and "visual basic like" background calculations.


Thanks for your help.

Mar 13, 2015 9:42 PM in response to Robert J McInnes

As I said, things I miss so far are:

a) Goal Seeking,

b) Macros, and "visual basic like" background calculations.



On b) you've got AppleScript. It's not built into Numbers the way VBA is built into Excel. You edit it externally via Script Editor. You can't activate an AppleScript with a button or user form; you have to trigger it from the menu or a keyboard shortcut. But it provides quite a bit of the functionality that VBA brings to Excel.


SG

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.

Highlight a Chart Value

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