Hi everyone

I'm new to the forum, so please excuse me if I've posted this in the wrong section.

Been trying to figure this out for like 40 minutes now and finally decided to seek some help from people with greater expertise in Excel than myself.

As part of my coursework I need to create a break-even chart, so I downloaded this template off the web. All works fine but the horizontal axis which represents the units only goes up to 4,000. However, the break even point for this particular venture is 5,939 so the chart doesn't look right.

Please see the print screen attached, and if anybody knows a solution to this, I would really appreciate some advice.

chart.png

Many thanks.