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

On Feb 14, 6:28*am, Rajendra <rsp...@gmail.com> 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?

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" <(E-Mail Removed)> wrote in message
news:cf06d083-dec6-433c-b984-(E-Mail Removed)...
> 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

On Feb 14, 2:27*am, Xt <the.christ...@clear.net.nz> wrote:
> On Feb 14, 6:28*am, Rajendra <rsp...@gmail.com> 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

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

On Feb 15, 6:31*am, Herbert Seidenberg <herbds7-ms...@yahoo.com>
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