CVP Graphs are simple to create with Microsoft Excel (i.e. 2016) using these simple steps:

• In Row 1 of a new Excel worksheet, set up column headings for Volume, Revenue, and Expenses.
• In Row 2, enter a volume of zero. Then calculate the corresponding revenues and expenses at that volume.
• In Row 3, enter a higher volume, such as the volume at the high end of the company's relevant range. Calculate the corresponding revenues and expenses at that volume.
• Highlight the data. Then click on the "Insert" tab on the menu bar and choose "Scatter With a Line" as the chart type. If you want to make the graph larger, choose "Move Chart Location" from the menu bar and select "New Sheet" and "OK".
• Click on "Insert" Textbox" to add labels for the breakeven point, revenue line, expense line, and so forth. Play around with the formatting features to get the look you want (for example, you may want to tilt the angle of the labels or add an arrow pointing to the break-even point, and so forth).
• Add a title to the graph, as well as labels for the axes.