Thread: Graph questions
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
First Aid Computing[_2_] First Aid Computing[_2_] is offline
external usenet poster
 
Posts: 18
Default Graph questions

Greetings. I am trying to create a chart based on data collected and do not
know how I would format/create such a monster.

Sample data:
12/16/08 6:10 AM 0m 43.57s
12/15/08 11:30 PM 0m 43.61s
12/15/08 6:07 AM 0m 47.15s
12/14/08 11:40 PM 0m 46.94s
12/14/08 10:10 AM 0m 46.97s
12/13/08 11:50 PM 0m 47.03s
Average: 0m 45.88s Standard: 0m 54.60s

I would like:
1) X-axis to be labeled with the date/time or at least the date.
2) y-axis labeled with the m/s but only within the min/max listed. No extra
above or below.
3) A line across the entire thing showing the standard that the data is
based against.
4) Optional: Is it possible to have the chart as an icon that can be clicked
to open up a window showing the cart?

Further information:
Excel 2000
Average experience