If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|