Placing an arrow on the series line in a line chart

[Rajendra]

Hi,

A line chart is made with the following values:

2 3 5 7 8

The x axis in the chart has the following values:
1 2 3 4 5

Is there a way using VBA to place an arrow on the line series
corresponding to the 1.5 point (or some similar point) on the x-
axis?

Thanks in advance for the help.

Regards,
Raj

 

[Xt]

Hi,

A line chart is made with the following values:

2       3       5       7       8

The x axis in the chart has the following values:
1       2      3      4       5

Is there a way using VBA to place an arrow  on the line series
corresponding to the 1.5 point (or some  similar point) on the x-
axis?

Thanks in advance for the help.

Regards,
Raj

Does it have to be a line chart or would an XY Scatter chart do as
well?

 

[Bernard Liengme]

I will send you a non-VBA method
best wishes

 

[Rajendra]

Does it have to be a line chart or would an XY Scatter chart do as
well?

It is a line chart.

Regards,
Rajendra

 

[Herbert Seidenberg]

Excel 2007
Place arrow on line chart.
Interpolate.
Measure in points.
With macro.
http://www.mediafire.com/file/ynzt3crq0nk/02_14_10.xlsm

 

[Rajendra]

Excel 2007
Place arrow on line chart.
Interpolate.
Measure in points.
With macro.http://www.mediafire.com/file/ynzt3crq0nk/02_14_10.xlsm

Thanks a ton, Herbert. This is more like it. I will play around with
it later. Sorry for the delay in responding; I was away travelling.

Regards,
Rajendra