How to Create a Break Even Chart in Excel

Label Data
1. Type 'Fixed Costs' into cell A1.
2. Type 'Unit Expense' into cell A2.
3. Type 'Unit Revenue' into cell A3.
4. Type 'Units' into cell C1.
5. Type 'Revenue' into cell D1.
6. Type 'Expense' into cell E1.
Input Data
7. Input your fixed costs of a production into cell B1. For example, if rent for the factory is $25 per month, then type '25.'
8. Input the cost of each unit you produce into cell B2. For example, if each widget costs you $5 to manufacture, type '5.'
9. Input the revenue you make for selling each unit into cell B3. For example, if each widget sells for $10, type '10.'
10. Input the number of units sold in column C, under the words 'Units.' For example, you might write '1' in cell C2, '2' in cell C3, and so on until you write '10' in cell C11.
11. Input the following formula into cell D2:
=$B$3*C2
12. Copy the formula from the previous step by left clicking on D2 and pressing 'Ctrl' and 'C' at the same time.
13. Highlight cells D3 through D11 by clicking D3 and dragging down to D11.
14. Paste the formula by pressing 'Ctrl' and 'V' at the same time.
15. Input the following formula into cell E2:
=$B$1 $B$2*C2
16. Copy the formula from the previous step into the cells in column E by following the same steps as copying and pasting the previous formula.
Create the Chart
17. Click 'Insert' > 'Scatter' > 'Scatter with smooth lines and markers' to insert a blank chart into your spreadsheet.
18. Right click on the chart and click 'Select Data' to display the Select Data Source dialog.
19. Click 'Add' under Legend Entries to display the Edit Series dialog.
20. Type 'Revenue' into the 'Series Name' text box.
21. Click the 'Series X Values' text box, then highlight cells D2 through D11, the entire Revenue column.
22. Click the 'Series Y Values' text box, then highlight cells C2 through C11, the entire Units column.
23. Click 'OK' to exit the Edit Series dialog.
24. Click 'Add' under Legend Entries to display the Edit Series dialog.
25. Type 'Expense' into the 'Series Name' text box.
26. Click the 'Series X Values' text box, then highlight cells E2 through E11, the entire Expense column.
27. Click the 'Series Y Values' text box, then highlight cells C2 through C11, the entire Units column.
28. Click 'OK' to exit the Edit Series dialog.
29. Click 'OK' to exit the Select Data Source dialog.