Placing an arrow on the series line in a line chart
in [Charts]
|
Prev: plot highlight
Next: refreshing charts
From: Rajendra on 13 Feb 2010 12:28 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
From: Xt on 13 Feb 2010 16:27 On Feb 14, 6:28 am, Rajendra <rsp...(a)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?
From: Bernard Liengme on 13 Feb 2010 16:30 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" <rspai9(a)gmail.com> wrote in message news:cf06d083-dec6-433c-b984-40c49651fff9(a)g8g2000pri.googlegroups.com... > 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
From: Rajendra on 13 Feb 2010 22:54 On Feb 14, 2:27 am, Xt <the.christ...(a)clear.net.nz> wrote: > On Feb 14, 6:28 am, Rajendra <rsp...(a)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
From: Herbert Seidenberg on 14 Feb 2010 20:31
Excel 2007 Place arrow on line chart. Interpolate. Measure in points. With macro. http://www.mediafire.com/file/ynzt3crq0nk/02_14_10.xlsm |