Please create a liner graph , and help me regarding this issue

yearly, base, multiplier, Base Share, Profit Share, total,
1300000, 50000, 13, 0.002, 33800, 83800



quarterly, base, multiplier, Base Share, Profit Share, total,
325000, 12500, 13, 0.002, 8450, 20950,


Please convert into a full table and graph.
This table represents a sliding scale of compensation.
Yearly pay is a base salary of $50,000.
The sliding scale is a .002 profit share per $100,000 of business revenue. Thus the scale is an exponential growth curve.
I would like a graph with Y axis Total Compensation (thus baseline is $50,000) and X axis is business revenue ranging from $0-$3,000,000.
Attached is a basic spreadsheet representing the calculations in a simple form.
Thanks!


Line graphs please. 2 separate.
Quarterly:
Y axis Total Compensation ranging from $12,500 to $50,000
X axis Business Revenue Ranging from $0 to $750,000
Yearly:
Y axis Total Compensation ranging from $50,000 to $200,000
X axis Business Revenue Ranging from $0 to $3,000,000

Welcome to the forum!

I think you might have somewhat misunderstood the way the forum works. We are here to help you to solve your issues rather than build solutions for you based on a brief: we have the paid commercial services section for that.

Please show us what you have tried so far that is not quite working as you intend: attach a workbook.

1. Make sure that your sample data are REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired results are also shown (mock up the results manually).

3. Make sure that all confidential data is removed or replaced with dummy data first (e.g. names, addresses, E-mails, etc.).

4. Try to avoid using merged cells as they cause lots of problems.

Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

Please pay particular attention to point 2 (above): without an idea of your intended outcomes, it is often very difficult to offer appropriate advice.