• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 26. Working with Chart Data > What-If Charting: Dragging Markers to Cha...

What-If Charting: Dragging Markers to Change Data

Because charts are linked to worksheet cells, you can use them to construct visual what-if scenarios with your data. For example, if you set up a break-even analysis in a worksheet and then plot fixed costs, variable costs, total costs, and gross margin in a chart, you can change fixed-cost assumptions in the worksheet and immediately see the effect on the gross-margin line in the chart.

You can also reverse this process in two-dimensional bar, column, line, and xy (scatter) charts. You can drag chart data markers—including picture markers—up or down and have Excel adjust the underlying worksheet. In the break-even analysis, for example, you can drag the chart's gross-margin line up so that it crosses 0 at a different point, and then find out on the worksheet how much you would need to reduce your fixed costs to achieve the increase in profit. This process is called graphical goal seeking.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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