LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2
Default Line graphs with multiple data sets

I need to create a line graph with the following information:

The Johnson family is planning a weeklong vacation in California and needs
to rent a car. They dont know exactly how far they will drive, but they
estimate between 400 and 800 miles. Here are their options:

Weekly Rates Daily Rates
$329 per week, unlimited mileage
$50 per day, unlimited mileage
$219 per week, plus 12 cents per mile
$40 per day, plus 3 cents per mile
Note: Any partial week will be charged a full weeks price. Note: Any
partial day will be charged a full days price.

Complete the following:

Represent the costs of each option in a data table.

Graph the cost of each option on the same table. (Make the y axis the total
rental costs per week and the x axis the total miles driven in a week.)

Use the information given to determine under what conditions the Johnson
family should choose each option.

Write the total weeks rental car cost as a function of the number of miles
driven in a week for each of the options.

You should include a table, and a graph of the problem.

Basically, I need to know how to change the y axis values as an adjustable
dollar amount and the x axis as the number of miles driven from 0 miles to
1000 miles.

I cannot figure out how to use the graph program of Microsoft 2007. I have
searched within the website, to no avail.

Any help will be appreciated.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple Line Graphs insitu Charts and Charting in Excel 5 September 9th 08 11:11 PM
how to create a line-chart with 2 sets of data who has different x Frank_C Charts and Charting in Excel 1 August 30th 08 03:55 PM
Multiple Plot Shading in Line Graphs ask72883 Charts and Charting in Excel 1 May 15th 06 07:28 PM
2 sets of data I need one line Tim Charts and Charting in Excel 1 February 25th 06 11:23 AM
Excel graphs - two data sets on the same y-axis? AndyB Excel Discussion (Misc queries) 2 April 24th 05 09:32 PM


All times are GMT +1. The time now is 04:42 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"