#1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2
Default 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   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1,104
Default 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   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1,180
Default 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   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2,722
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Goal line or target line to Excell 2007 Chart hawaiiham2000 Charts and Charting in Excel 5 October 2nd 09 05:35 PM
How do I convert a line chart to a vertical line chart in Excel Gerty Charts and Charting in Excel 1 August 20th 09 04:28 PM
Problem adding vertical marker line to line chart lbb Charts and Charting in Excel 6 January 9th 09 10:02 AM
change last serie to be line in the line-column Excel chart in Wor Eric Charts and Charting in Excel 3 June 30th 07 04:58 PM
Make a line in a bar chart, and change color of any bars that exceed the line MarkM Excel Discussion (Misc queries) 4 July 5th 06 04:06 PM


All times are GMT +1. The time now is 08:42 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"