Create a break-even chart in excel from a variable data range

The attached file contains: 1. A worksheet with a picture of a chart 2. A worksheet where data will be shown (currently just shows headings) 3. A worksheet where any calculations used to populate the chart would be shown and documented The data sheet will be populated with content from another application, under the headings shown at the top of this worksheet. The number of records within the content will vary significantly, and could be greater than 10,000 records, so a range based on a fixed number of cells should be avoided. I would like to replace the picture of the chart with an excel-based chart, generated from data in the data worksheet. The format of the chart should be the same as the current picture. Also the values calculated for total fixed cost, variable cost, break-even sales etc, should be shown in the cells next to the chart as set out in the attached. Note that the calculation and chart is a little different from traditional break-even analysis, which tends to show units sold, rather than sales value. The source data for variable cost will be cost per $ revenue, rather than cost per unit