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.

 Indicate intersection point on a two-line graph
 Author Name Remember Me? Password
 Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

## Indicate intersection point on a two-line graph

 Thread Tools Display Modes
#1
November 30th 07, 08:01 PM posted to microsoft.public.excel.charting
 Greg[_2_] external usenet poster 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
 Ads
#2
November 30th 07, 08:46 PM posted to microsoft.public.excel.charting
 John Mansfield external usenet poster 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, 05:37 PM posted to microsoft.public.excel.charting
 John Mansfield external usenet poster 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 Display Modes Linear Mode

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off
 Forum Jump User Control Panel Private Messages Subscriptions Who's Online Search Forums Forums Home Excel Newsgroups     Excel Discussion (Misc queries)     Setting up and Configuration of Excel     New Users to Excel     Excel Worksheet Functions     Links and Linking in Excel     Charts and Charting in Excel     Excel Programming About ExcelBanter     About this forum

 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:52 AM.

 - Contact Us - ExcelBanter forum home - FAQ - Links - Privacy Statement - Top

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