mean temp average and charting

[southbayrik]

HELP I would like to make a chart in Excel 2010 containing 5 different cities and the temperatures over a 10 day period and find mean temp for each city

[Jester0001]

You would need to create a table in Excel that will be large enough to hold your raw data (city names and temperatures). Then, you could use the AVERAGE function in a column to average all of the temperatures.

Excel AVERAGE function:
http://www.homeandlearn.co.uk/excel2...l2007s5p1.html

	Day 1	Day 2	Day 3	Day 4	Day 5	Day 6	Day 7	Day 8	Day 9	Day 10	=Average()
City 1	98	99	100	101	102	89	95	96	98	97	97.5
City 2
City 3
City 4
City 5

Once you have your table and data, you would create a chart based off of that data table.

Creating Excel 2010 Charts:
http://www.dummies.com/how-to/conten...10-charts.html