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 ...
Get Microsoft® Office Excel 2003 Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
