Guidance On what are the recommend method or how to display Graph with 2D Table

CuriousMonkeyTan

New Member
Joined
Aug 20, 2019
Messages
1
Hi all to paint the context i not here to seek for answers but for guidance:
Below is the following question.[TABLE="width: 490"]
<colgroup><col span="7"></colgroup><tbody>[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 6"]The Popular rental car companies in town are Goldee and Supreme.[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 7"]Goldee charges $195.99 per day plus $0.85 per kilometer, and Supreme Charges $175.99 a day plus $1.29 per Kilometer.[/TD]
[/TR]
[TR]
[TD="colspan: 5"]You are taking a trip upcountry and will need to rent a car.[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 7"]After Looking through the details of both Rental Car, following action are to be made:[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 7"]● Construct a spreadsheet model to anaylze the two choices. Sketch the influence diagram of your model.[/TD]
[/TR]
[TR]
[TD="colspan: 7"]● It is likey that this trip will span 3 to 5 days and involve a significant amount of driving. [/TD]
[/TR]
[TR]
[TD="colspan: 5"] Which company should you go with? Explain your choice.[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 7"]● At what travel distances will you be indifferent to either rental company? [/TD]
[/TR]
[TR]
[TD="colspan: 7"] If the trip is longer than 5 days, will the indifferent distance be longer or shorter[/TD]
[/TR]
</tbody>[/TABLE]

1) I have managed to created two 2D Tables for each of the companies (Supreme and Goldee). Where it shows the computed price of both
independent clause ( Rental Price of Car and Total Travelling Cost depending on Days)

2) Right now i am currently trying to plot a graph to serve as a presentation of the break even point where Supreme is better than Goldee over time. However, after searching on youtube and google i can'ts seem to find a guide on how to make a single graph from two 2D Tables

3) Lastly would it be better to use Goal Seek/ Solver to proves the the last 2 question which is (At what travel distances will you be indifferent to either rental company?)
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

Forum statistics

Threads
1,223,892
Messages
6,175,236
Members
452,621
Latest member
Laura_PinksBTHFT

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top