Using What-If Analysis, you can visualize the effects of different variables, making it easier to assess risks and opportunities. In Excel, three primary tools are available for performing What-If ...

The variables for the chart are the values listed in each column. Once you have your table populated, you can use the Insert Chart feature to create the chart. Open a blank Excel spreadsheet.