Remember Me?

#1
November 30th 07, 09:01 PM posted to microsoft.public.excel.charting
 external usenet poster First recorded activity by ExcelBanter: Nov 2007 Posts: 1
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

#2
November 30th 07, 09:46 PM posted to microsoft.public.excel.charting
 external usenet poster First recorded activity by ExcelBanter: Mar 2007 Posts: 235
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, 06:37 PM posted to microsoft.public.excel.charting
 external usenet poster First recorded activity by ExcelBanter: Mar 2007 Posts: 235
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 Search this Thread Search this Thread: Advanced Search Display Modes Linear Mode

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Nana Adwoa Charts and Charting in Excel 3 December 12th 09 10:09 PM SASPerson Charts and Charting in Excel 1 November 15th 06 07:43 PM tvtime Excel Worksheet Functions 20 July 27th 06 07:20 PM Keylay31 Charts and Charting in Excel 3 July 13th 06 08:41 AM rk0909 Excel Discussion (Misc queries) 4 October 28th 05 09:44 PM

All times are GMT +1. The time now is 09:07 PM.