Line Chart

  • Thread starter Thread starter Sandra P
  • Start date Start date
S

Sandra P

What I want to do is somehow label the breakeven point in a line chart. I
have 5 different lines that intersect (breakeven) at different points. In
other words, if line A & line B intersect at year 3.5, is there a way for
"3.5" to be displayed above the lines? Also, is there a way for the
intersection point to be circled, or in some other way made prominent?
 
Here is some data; tow lines that cross
x y z
1 2 6.25
2 3 5.75
3 4 5.25
4 5 4.75
5 6 4.25
6 7 3.75
7 8 3.25
8 9 2.75
9 10 2.25
10 11 1.75
In E1 and F1 I use SLOPE and INTERCEPT to find m and c of the first data
series
In E2 and F2 ditto for second
In E3 I compute the x value where they intersect =(c2-c1)/(m1-m2)
=(F2-F1)/(E1-E2)
In F3 I compute the corresponding y value y =m1*x1+c1; =E1*E3+F1
Select E3:F3 and use Copy; clcik the chart; use Edit | Paste Special | New
SERIES with x-value in first column; clcik OK
Format he new data series (one point) as a circle
Format again and specify Data Labels
Format Data Label to show as many decimal point (2 is enough) as needed
You may need to delete the legend for Series 3
Careful: you must select both the makers and the text in the legend before
hitting Deelte
Otherwise you could loose a lot of work (Ctrl+Z might bring it back)
(save file first, in case you delete the series not just its legend)

Email me (addy from my website) if you want a sample file
 
Is the break even point a data point, or is it determined by visual
inspection? Either way, you need to have a point there in order to plot it.
If visual inspection, you'll need to dig up your algebra book and write a
formula that calculates the intersection point.

Once you have the point identfied, you can either active a data label and
overwrite the text to whatever you want it to display, or you can use a
y-error bar to generate what looks like a label with leader line.

To change the single data point's appearance:
Create a picture (import, drawing toolbar, etc) of what you want the marker
to look like. Copy the picture, select the single data point (two single
clicks usually) and then paste. the data point has now adopted the appearance
of the picture.
 
Back
Top