O'Reilly logo

Microsoft® Office Excel 2003 Inside Out by Mark Dodge, Craig Stinson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required