|
| 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
November 30th 07, 08:01 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
Indicate intersection point on a two-line graph
Hi,
I have a simple line graph with two lines (line A and line B). They intersect at a given point (the break even point). How do I indicate on the graph that this is the break even point. I know its very easy to do with an arrow and text box. However, I would like the arrow and text box to move to a new intersection as I change the numbers around. Thanks, Greg 
|
| Ads |
|
#2
November 30th 07, 08:46 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
Indicate intersection point on a two-line graph
Andy Pope has an example on his site which should help:
http://www.andypope.info/charts/intersection.htm -- John Mansfield http://cellmatrix.net "Greg" wrote: > Hi, > > I have a simple line graph with two lines (line A and line B). They > intersect at a given point (the break even point). How do I indicate > on the graph that this is the break even point. I know its very easy > to do with an arrow and text box. However, I would like the arrow and > text box to move to a new intersection as I change the numbers around. > > Thanks, > Greg >
|
|
#3
December 1st 07, 05:37 PM
posted to microsoft.public.excel.charting
|
|||
|
|||
|
Indicate intersection point on a two-line graph
Below is an example that shows how to use a textbox to show the breakeven
point in a breakeven chart: http://www.cellmatrix.net/index.php/..._dynamic_label -- John Mansfield http://cellmatrix.net "John Mansfield" wrote: > Andy Pope has an example on his site which should help: > > http://www.andypope.info/charts/intersection.htm > > -- > John Mansfield > http://cellmatrix.net > > > > > > "Greg" wrote: > > > Hi, > > > > I have a simple line graph with two lines (line A and line B). They > > intersect at a given point (the break even point). How do I indicate > > on the graph that this is the break even point. I know its very easy > > to do with an arrow and text box. However, I would like the arrow and > > text box to move to a new intersection as I change the numbers around. > > > > Thanks, > > Greg > >
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How do i locate the point of intersection of two lines graphs | Nana Adwoa | Charts and Charting in Excel | 3 | December 12th 09 09:09 PM |
| How to change color of line and point markers on a line graph | SASPerson | Charts and Charting in Excel | 1 | November 15th 06 06:43 PM |
| Intersection point return data | tvtime | Excel Worksheet Functions | 20 | July 27th 06 07:20 PM |
| How do I point out a specific date on a line graph in Excel? | Keylay31 | Charts and Charting in Excel | 3 | July 13th 06 08:41 AM |
| Intersection point in graphs | rk0909 | Excel Discussion (Misc queries) | 4 | October 28th 05 09:44 PM |
Linear Mode
