A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Plotting calculated point



 
 
Thread Tools Display Modes
  #1  
Old May 17th, 2009, 01:19 PM posted to microsoft.public.excel.misc
Bradley Steve
external usenet poster
 
Posts: 1
Default Plotting calculated point

My data
781 249.77
781 449.72
766 649.93
761 849.49
723 1049.39
719 1249.65
692 1449.54
672 1649.80
644 1849.70
636 2049.57
597 2249.47
584 2449.72
is used to create a line chart. No problems
I then have been using
=IF(AND(B10F$4,B11=F$4),FORECAST(F$4,A10:A11,B10 :B11)," ")
to calculate a point for a particular value in A.
What I am unable to do is to plot this point on the graph and show lines
from the x & y axes to this point.
Any suggestions?
  #2  
Old May 17th, 2009, 02:56 PM posted to microsoft.public.excel.misc
Joel
external usenet poster
 
Posts: 2,855
Default Plotting calculated point

You may need to change the axis to make it larger to include the points.
Select the X or Y axis with mouse the double click on the highlighted axis.
go to Scale Tab to modify axis as required.

"Bradley Steve" wrote:

My data
781 249.77
781 449.72
766 649.93
761 849.49
723 1049.39
719 1249.65
692 1449.54
672 1649.80
644 1849.70
636 2049.57
597 2249.47
584 2449.72
is used to create a line chart. No problems
I then have been using
=IF(AND(B10F$4,B11=F$4),FORECAST(F$4,A10:A11,B10 :B11)," ")
to calculate a point for a particular value in A.
What I am unable to do is to plot this point on the graph and show lines
from the x & y axes to this point.
Any suggestions?

  #3  
Old May 17th, 2009, 09:28 PM posted to microsoft.public.excel.misc
Bradley Steve[_2_]
external usenet poster
 
Posts: 2
Default Plotting calculated point

The calculated data point will always be within the limits of the data. For a
specific point eg 653 the calculated x value is 1728, but I am unable to plot
this 653, 1728 point.

"joel" wrote:

You may need to change the axis to make it larger to include the points.
Select the X or Y axis with mouse the double click on the highlighted axis.
go to Scale Tab to modify axis as required.

"Bradley Steve" wrote:

My data
781 249.77
781 449.72
766 649.93
761 849.49
723 1049.39
719 1249.65
692 1449.54
672 1649.80
644 1849.70
636 2049.57
597 2249.47
584 2449.72
is used to create a line chart. No problems
I then have been using
=IF(AND(B10F$4,B11=F$4),FORECAST(F$4,A10:A11,B10 :B11)," ")
to calculate a point for a particular value in A.
What I am unable to do is to plot this point on the graph and show lines
from the x & y axes to this point.
Any suggestions?

  #4  
Old May 17th, 2009, 09:34 PM posted to microsoft.public.excel.misc
Joel
external usenet poster
 
Posts: 2,855
Default Plotting calculated point

Did you try a scatter plot instead of a line plot?

"Bradley Steve" wrote:

The calculated data point will always be within the limits of the data. For a
specific point eg 653 the calculated x value is 1728, but I am unable to plot
this 653, 1728 point.

"joel" wrote:

You may need to change the axis to make it larger to include the points.
Select the X or Y axis with mouse the double click on the highlighted axis.
go to Scale Tab to modify axis as required.

"Bradley Steve" wrote:

My data
781 249.77
781 449.72
766 649.93
761 849.49
723 1049.39
719 1249.65
692 1449.54
672 1649.80
644 1849.70
636 2049.57
597 2249.47
584 2449.72
is used to create a line chart. No problems
I then have been using
=IF(AND(B10F$4,B11=F$4),FORECAST(F$4,A10:A11,B10 :B11)," ")
to calculate a point for a particular value in A.
What I am unable to do is to plot this point on the graph and show lines
from the x & y axes to this point.
Any suggestions?

  #5  
Old May 17th, 2009, 10:17 PM posted to microsoft.public.excel.misc
Bradley Steve[_2_]
external usenet poster
 
Posts: 2
Default Plotting calculated point

Many thanks. I have now created what I required

"joel" wrote:

Did you try a scatter plot instead of a line plot?

"Bradley Steve" wrote:

The calculated data point will always be within the limits of the data. For a
specific point eg 653 the calculated x value is 1728, but I am unable to plot
this 653, 1728 point.

"joel" wrote:

You may need to change the axis to make it larger to include the points.
Select the X or Y axis with mouse the double click on the highlighted axis.
go to Scale Tab to modify axis as required.

"Bradley Steve" wrote:

My data
781 249.77
781 449.72
766 649.93
761 849.49
723 1049.39
719 1249.65
692 1449.54
672 1649.80
644 1849.70
636 2049.57
597 2249.47
584 2449.72
is used to create a line chart. No problems
I then have been using
=IF(AND(B10F$4,B11=F$4),FORECAST(F$4,A10:A11,B10 :B11)," ")
to calculate a point for a particular value in A.
What I am unable to do is to plot this point on the graph and show lines
from the x & y axes to this point.
Any suggestions?

 




Thread Tools
Display Modes

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 Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:58 AM.


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