+ Reply to Thread
Results 1 to 2 of 2

excel graph - select data points on line graph and return its corresponding vaue

  1. #1
    Registered User
    Join Date
    08-26-2015
    Location
    mumbai
    MS-Off Ver
    2013
    Posts
    2

    excel graph - select data points on line graph and return its corresponding vaue

    Hi Everyone,

    Greetings for the day..

    Well, I have a simple line chart, and I want to select any two data points of line, and wants in return its corresponding value.

    For example, my 11 different points are below. Simple line graph can be drawn connecting these data points. When I click on any data point on line, I want to know its respective X and Y axis value. Lets say, I select 3rd data point on the line graph, so I should get its X and Y axis value (here time and price) as 9:32 and 8506. The user can select two data points, and I want both data points value in return.

    Thank you All.


    Sr. No. TIME PRICE
    1 9:30 8500
    2 9:31 8502
    3 9:32 8506
    4 9:33 8501
    5 9:34 8496
    6 9:35 8491
    7 9:36 8503
    8 9:37 8510
    9 9:38 8497
    10 9:39 8516
    11 9:40 8528

    Regards,
    Vishal

  2. #2
    Registered User
    Join Date
    08-26-2015
    Location
    mumbai
    MS-Off Ver
    2013
    Posts
    2

    Re: excel graph - select data points on line graph and return its corresponding vaue

    Dear All,

    Just to give more clarity about my output required, I am giving below example. Pls go through it.

    I want the chosen data points' X and Y axis value to get populated in a table. So, when I select first data point, I want its value in First chosen data point. When I select second data point of graph, I want its value in 2nd chosen point in table.

    For example, I have selected 3rd data point first, and then I selected 6th data point. So my output table should populate both the data point' value as below.

    Output Table:

    My out put table should be as below.

    Data point X axis value Y axis value
    First chosen 09:32 8506
    Second chosen 09:35 8491

    Regards,
    Vishal

+ 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. [SOLVED] Bar & Line graph for 30 day rolling data points
    By ardent_guy in forum Excel Charting & Pivots
    Replies: 10
    Last Post: 06-25-2014, 05:16 PM
  2. Replies: 1
    Last Post: 06-05-2012, 02:26 PM
  3. [SOLVED] How do I update my static line graph to allow a user to select which data to graph
    By capcon in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 12-31-2011, 10:22 PM
  4. Problem charing w/line graph when a series has missing data points
    By tvdij in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 04-08-2008, 04:05 AM
  5. Naming specific data points in line graph
    By Innov8ive in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-02-2007, 03:54 PM
  6. [SOLVED] Need 2 rows to display X axis data points for a line graph
    By SusanG in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-08-2006, 01:40 PM
  7. missing data points causes my line graph not to connect
    By liebw in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 09-01-2005, 08:05 AM

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