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

[VISHAL KAPASI]

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 the line, graph I want to know its respective X and Y axis value.

Let’s 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.



[TABLE="width: 0"]
<tbody>[TR]
[TD]Sr. No.
[/TD]
[TD]TIME
[/TD]
[TD]PRICE
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]9:30
[/TD]
[TD]8500
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]9:31
[/TD]
[TD]8502
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]9:32
[/TD]
[TD]8506
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]9:33
[/TD]
[TD]8501
[/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD]9:34
[/TD]
[TD]8496
[/TD]
[/TR]
[TR]
[TD]6
[/TD]
[TD]9:35
[/TD]
[TD]8491
[/TD]
[/TR]
[TR]
[TD]7
[/TD]
[TD]9:36
[/TD]
[TD]8503
[/TD]
[/TR]
[TR]
[TD]8
[/TD]
[TD]9:37
[/TD]
[TD]8510
[/TD]
[/TR]
[TR]
[TD]9
[/TD]
[TD]9:38
[/TD]
[TD]8497
[/TD]
[/TR]
[TR]
[TD]10
[/TD]
[TD]9:39
[/TD]
[TD]8516
[/TD]
[/TR]
[TR]
[TD]11
[/TD]
[TD]9:40
[/TD]
[TD]8528
[/TD]
[/TR]
</tbody>[/TABLE]

Regards,
Vishal

 

[Shrikant]

BTW A simple XY scatter plot would do that.

 

[VISHAL KAPASI]

Dear All,


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

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:</SPAN>

My out put table should be as below.
</SPAN>
[TABLE="width: 0"]
<TBODY>[TR]
[TD]Data point</SPAN>
[/TD]
[TD]X axis value</SPAN>
[/TD]
[TD]Y axis value</SPAN>
[/TD]
[/TR]
[TR]
[TD]First chosen</SPAN>
[/TD]
[TD]09:32</SPAN>
[/TD]
[TD]8506</SPAN>
[/TD]
[/TR]
[TR]
[TD]Second chosen</SPAN>
[/TD]
[TD]09:35</SPAN>
[/TD]
[TD]8491</SPAN>
[/TD]
[/TR]
</TBODY>[/TABLE]

 

[Shrikant]

Ok. Now that is something different.
Still a few questions.
1. Is that line graph is based on some source data base?
2. Will the selection always be in the chronological order? I mean is it okay if First selection could be 6th point and second could be 3rd point..

I am just trying to understand purpose of this entire exercise..

 

[VISHAL KAPASI]

Dear Shrikant,

Yes surely, I would answer to your curiosity. The purpose of this exercise is to let the user know the return i.e.diff. between two data point's price (Y axis) as per his entry and exit (first and second data) points with respective time lines (X axis values).

Now, I would answer to above 2 questions.

1. Yes, the line graph is based on source data base. In above example, 11 data points are source for plotting line graph.

2. Yes, the selection will be chronological order. As first point (entry point) will be ahead of 2nd data point (exit point).

Hope, you get the purpose behind this exercise.

Will appreciate if you could help me achieve desired result.

Thanks & Regards,
Vishal Kapasi



1.

 

[Shrikant]

Hope this helps.


http://www.mrexcel.com/forum/excel-...ications-return-datapoint-embedded-chart.html