• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Goal Seeking with Charts

If you have your data graphed in a 2D bar, column, line, or XY chart, you can run Goal Seek by using the mouse to drag a data marker to a new position. If the data marker represents a formula, Excel uses Goal Seek to work backward and derive the appropriate formula input values.

The following example helps explain this process. Suppose that you want to invest some money every year so that in 10 years, you'll have $150,000. Assuming a constant interest rate, how much do you need to set aside annually to reach your goal? The solution is to adjust the chart data marker at 10 years so that it has the value $150,000. The following procedure shows you the steps to follow:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint