Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 30th 07, 08:01 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2007
Posts: 1
Default 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   Report Post  
Old November 30th 07, 08:46 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2007
Posts: 235
Default 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   Report Post  
Old December 1st 07, 05:37 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2007
Posts: 235
Default 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



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
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


All times are GMT +1. The time now is 03:51 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017