troubleshooting Question

Display the break-even area on an excel chart

Avatar of Terrygordon
Terrygordon asked on
Microsoft OfficeMicrosoft Excel
5 Comments1 Solution36 ViewsLast Modified:
Hi Experts

I am constructing a break-even chart, based on the following data:

Output      Indirect Costs      Total Cost      Revenue
0              £40,000                      £40,000              £0
100              £40,000                      £52,000              £20,000
200              £40,000                      £64,000              £40,000
300              £40,000                      £76,000              £60,000
400              £40,000                      £88,000              £80,000
500              £40,000                      £100,000      £100,000
600              £40,000                      £112,000      £120,000
700              £40,000                      £124,000      £140,000
800              £40,000                      £136,000      £160,000
900              £40,000                      £148,000      £180,000
1000      £40,000                      £160,000      £200,000

The basic chart displays fine. However, I would like to include a box, that clearly shows the break-even point, as in the example below.

I would like this box to be part of the chart, so that it changes dynamically when you change the figures, i.e. in the above table, the break-even point is 500 units, but if I changed the revenue or costs, the break-even point would be higher or lower - I'd like the box to change accordingly.

Any assistance would be greatly appreciated.
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 5 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros