excel chart showing movable graph at what point we make a profit

M

Mim

in a business would like to make a chart based on accumulated Earnings &
Profit/Loss for year to date, perhaps movable showing our break even point
and by moving chart to a another earnings figure what profit we should make.

For example put in earnings for YTD Profit/Loss YTD then I can move the
earnings part of the chart to show what our profit would be for a given
earnings figure.

Alternatively

If For example if we earn $200 for year so far and profit is $0 but any
amount over that is 18% profit so I can move chart line to say $240 and it
will say what profit I will make.

Hope I make sense with these two questions
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data points in chart incorrect 0
Creating a profit and loss from MSQuery Data 2
animated Graph presentation 0
Beginner needs help to make chart or graph or pie 1
Floating Year-To-Date Line 3
Outlier data point for Chart in Excel 1
How to chart a profit & loss statement/Profitability analysis statement in Excel Charts 2
Thermometer chart with 2 Y axis? 3

Top