Microsoft Office Tutorials and References
In Depth Information
Appendix: Sensitivity Analysis—One-and Two-Way Data Tables for Excel 2003 and Mac Excel 2011
FIGURE 17.15 Creating the Break-Even Chart
FIGURE 17.16 Break-Even Point Chart
APPENDIX: SENSITIVITY ANALYSIS—ONE- AND TWO-WAY DATA
TABLES FOR EXCEL 2003 AND MAC EXCEL 2011
Excel 2003: Select the table
.
Insert menu
.
Chart
.
Scatter. Or use the Chart
Wizard.
Excel 2003
The Data Table in Excel 2003 or previous versions is under the Data Menu. All
the rest is identical. For the Break-Even Point Chart using the Scatter Chart: Select the
Data Table,
.
Insert menu
.
Chart
.
Scatter, or use the Chart Wizard.
 
Search JabSto ::




Custom Search