Placing an arrow on the series line in a line chart
 

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

Placing an arrow on the series line in a line chart
 

On Feb 14, 6:28*am, Rajendra wrote:
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?

Placing an arrow on the series line in a line chart
 

I will send you a non-VBA method
best wishes
--
Bernard Liengme
Microsoft Excel MVP
people.stfx.ca/bliengme
email address: remove uppercase characters

"Rajendra" wrote in message
...
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

Placing an arrow on the series line in a line chart
 

On Feb 14, 2:27*am, Xt wrote:
On Feb 14, 6:28*am, Rajendra wrote:



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?

It is a line chart.

Regards,
Rajendra

Placing an arrow on the series line in a line chart
 

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

Placing an arrow on the series line in a line chart
 

On Feb 15, 6:31*am, Herbert Seidenberg
wrote:
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