+ Reply to Thread
Results 1 to 1 of 1

Viewing graph data values

  1. #1
    Registered User
    Join Date
    10-05-2010
    Location
    Israel
    MS-Off Ver
    Excel 2013
    Posts
    11

    Viewing graph data values

    I have a scatter graph with lots (thousands) of data points, and I am displaying it as a line with no data point markers.

    when I click on the graph, a box appears near where I click, (see attached). Using the left and right cursor control keys I can move the box along the graph line.

    I would like to know the value of the data point at the exact location of the box. Hovering the cursor gives the value at the cursor location, not the box location, and I would like to see how the values change as the box moves along the graph line. I think it would be neat if the corresponding cells in the worksheet would be highlighted as the box moves. Also, does anyone know what this box is called?
    Attached Images Attached Images

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Get data values from a website's graph (HTML)
    By WellNy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-31-2017, 08:12 PM
  2. Threshold values from graph or data
    By mondoyle in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-19-2014, 05:17 AM
  3. Problems with viewing values in simple calculations
    By jazz_bass in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-28-2012, 06:28 PM
  4. Unwanted graph data for future values.
    By Canus in forum Excel General
    Replies: 3
    Last Post: 11-09-2010, 04:28 AM
  5. Problem: How to run Excel Solver while viewing a graph?
    By holditall in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-30-2008, 01:24 PM
  6. viewing values vs formulas
    By maacmaac in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-08-2008, 03:40 PM
  7. Viewing boxed values in macro script
    By Aussie_Striker in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-02-2007, 01:13 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1