• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Sales and Wage Correlation @ 13%

M

melvin

Member
Gday all,
I have been trying to create a graph that showcases the below objective

i.e. If sales range is below $2M, then stores will be over 13% in wage
The objective is to advise the sales team that, do not open any stores below xM in sales base, as the target to achieve 13% will not be met.
I have drawn a graph to showcase what I am trying to achieve.

Any assistance would be appreciated.
Melv
 

Attachments

  • sales and wage.xlsx
    126.1 KB · Views: 2
Thanks mate. Much appreciated. I was struggling to get the x and Y axis with the Sales and Wage. But I understand now , how you made it work.Have a good day. Melv.
 
Vletm,
Mate what does the dotted line showcase ? Is it a trend line that shows as sales reduces wage increases ?
 
melvin
the dotted line:
Based Your sample layout - You have there something same.
It's a trendline with Power-option .. to show that Your drawing was ... 'upside-down'.
Activate it with 'right-mouse' and modify as needed.
 
Thanks mate. Much appreciated. I will sturdy a bit on the power option, so i can explain if asked.
Cheers
 
You must log in or register to reply here.
Back
Top