I have the following problem: I am using Delphi XE3 with TeeChart and I'd like to retrieve a Y value or the value index of a serie by a given X value. My serie is a time series with dates on the X axis. I know the date on the chart and I want to display the nearest corresponding Y value to this date.
Is there any method or function of the TChart or TChartSeries component to achieve this? Or do I need to iterate through the series until I reached the selected date?
It is not possible to use the CursorPostion methods, because the cursor could be anywhere.
Thanks in advance for your help.
You can use Locate
method of TChartValueList
to get index of appropriate data entry.
Example from help:
tmp:=LineSeries1.XValues.Locate(EncodeDate(2007,1,1));
if tmp<>-1 then ...
Edit: This method works for exact coincidence.
If your X-values are sorted (default mode), then you can use binary search in XValues to find the closest value quickly.
For example, we can modify this code to return the closest value index instead of -1
, or use linear interpolation (if applicable) for two neighbor values.
//assumes A.Order = loAscending (default)
function FindClosestIndex(const Value: Double; A: TChartValueList): Integer;
var
ahigh, j, alow: integer;
begin
// extra cases
if A.Count = 0 then
Exit(-1);
if Value <= A.First then
Exit(0);
if Value >= A.Last then
Exit(A.Count - 1);
// binary search
alow := 0;
ahigh := A.Count - 1;
while ahigh - alow > 1 do begin
j := (ahigh + alow) div 2;
if Value <= A[j] then
ahigh := j
else
alow := j;
end;
// choose the closest from ahigh, alow
Result := ahigh - Ord(A[ahigh] - Value >= Value - A[alow])
end;