arrun
07-04-2008, 01:50 AM
Hi all,
Suppose i plot a graoh on following figures :
0 31273.36386
1 31259.83531
2 31246.33099
3 31232.85093
4 31219.39516
5 31205.96371
6 31192.55661
7 31179.1739
8 31165.81561
9 31152.48176
10 31139.17239
11 31125.88753
12 31112.62722
13 31099.39147
14 31086.18033
15 31072.99383
Now I want to highlight the point 31099.391 (third last) by the following manner :
from that point on plot, I want to draw a vertical line which will cut the x-axis and another horizontal line that will cut the y-axis.
Can anyone please tell me how to do that? I already gone through http://theclosetentrepreneur.com/how-to-add-a-vertical-line-to-an-excel-xy-chart but is not working for my problem.
Suppose i plot a graoh on following figures :
0 31273.36386
1 31259.83531
2 31246.33099
3 31232.85093
4 31219.39516
5 31205.96371
6 31192.55661
7 31179.1739
8 31165.81561
9 31152.48176
10 31139.17239
11 31125.88753
12 31112.62722
13 31099.39147
14 31086.18033
15 31072.99383
Now I want to highlight the point 31099.391 (third last) by the following manner :
from that point on plot, I want to draw a vertical line which will cut the x-axis and another horizontal line that will cut the y-axis.
Can anyone please tell me how to do that? I already gone through http://theclosetentrepreneur.com/how-to-add-a-vertical-line-to-an-excel-xy-chart but is not working for my problem.