Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Plotting Point on Gridline | Charts and Charting in Excel | |||
Plotting X and Y to a single point | Charts and Charting in Excel | |||
I need more general XY point to point plotting than XY scatter in | Charts and Charting in Excel | |||
How do I get a value of a calculated point on an excel line chart? | Charts and Charting in Excel | |||
plotting 2 variables as scatter and naming each point | Charts and Charting in Excel |