Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Line Chart
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? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Line Chart
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 -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Sandra P" wrote in message ... 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? |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Line Chart
Excel 2007
Multiple complex curve intersections. With labels and markers. No math. One click macro solution. http://www.mediafire.com/file/yg0tjduzv10/11_06_09.xlsm |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Line Chart
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. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Sandra P" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Goal line or target line to Excell 2007 Chart | Charts and Charting in Excel | |||
How do I convert a line chart to a vertical line chart in Excel | Charts and Charting in Excel | |||
Problem adding vertical marker line to line chart | Charts and Charting in Excel | |||
change last serie to be line in the line-column Excel chart in Wor | Charts and Charting in Excel | |||
Make a line in a bar chart, and change color of any bars that exceed the line | Excel Discussion (Misc queries) |