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

A lot depends on how you have your data setup.
First, I'm assuming you're mainly dealing with just two columns. First
column is formatted as dates.
Second column can be entered as a decimal number, special format as
0"m "00.00"s"
Create your chart, setting up proper y and x axis. You will probably need to
format the axis after you create the chart to display the same way.

Under format axis-Scale, change min and max to appropriate values. If this
is not acceptable, the other alternative I see is using a macro to edit chart
properties after it finds the min/max values.

To add your standard line, simply copy the standard next to all the cells
used in first series, and add another series to the chart using these values.
Will create a flat line on your chart.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"First Aid Computing" wrote:

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

Was hoping to not have to copy the standard over and over, etc. ad nauseum.
Apparently Microsoft never thought that someone would need a just a simple
line across a graph somewhere. I suppose I could if I had to and just make
the font white. Will take more time, but probably not much more that has
already been spent on this. Bosses like pretty charts. :)

How would I do the macro you mentioned? I have 14 pages of data in chunks
of 10 or so data/section (read lots of items with little data so far, it's a
work in progress).
Having to manually adjust the min/max for every chart would make my head
explode.

Any ideas on optional question 4? Otherwise, I'll have to resize the chart
to the hight of the data collected, thus making it quite small until more
data is taken.
"Luke M" wrote:

A lot depends on how you have your data setup.
First, I'm assuming you're mainly dealing with just two columns. First
column is formatted as dates.
Second column can be entered as a decimal number, special format as
0"m "00.00"s"
Create your chart, setting up proper y and x axis. You will probably need to
format the axis after you create the chart to display the same way.

Under format axis-Scale, change min and max to appropriate values. If this
is not acceptable, the other alternative I see is using a macro to edit chart
properties after it finds the min/max values.

To add your standard line, simply copy the standard next to all the cells
used in first series, and add another series to the chart using these values.
Will create a flat line on your chart.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"First Aid Computing" wrote:

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

Hi,

To get your horizontal line across the chart, you only need to enter a
single point using an appropriate x and y value, and then add a horizontal
error bar to that point, extending as far as you wish in either direction.

Dave

"First Aid Computing" wrote:

Was hoping to not have to copy the standard over and over, etc. ad nauseum.
Apparently Microsoft never thought that someone would need a just a simple
line across a graph somewhere. I suppose I could if I had to and just make
the font white. Will take more time, but probably not much more that has
already been spent on this. Bosses like pretty charts. :)

How would I do the macro you mentioned? I have 14 pages of data in chunks
of 10 or so data/section (read lots of items with little data so far, it's a
work in progress).
Having to manually adjust the min/max for every chart would make my head
explode.

Any ideas on optional question 4? Otherwise, I'll have to resize the chart
to the hight of the data collected, thus making it quite small until more
data is taken.
"Luke M" wrote:

A lot depends on how you have your data setup.
First, I'm assuming you're mainly dealing with just two columns. First
column is formatted as dates.
Second column can be entered as a decimal number, special format as
0"m "00.00"s"
Create your chart, setting up proper y and x axis. You will probably need to
format the axis after you create the chart to display the same way.

Under format axis-Scale, change min and max to appropriate values. If this
is not acceptable, the other alternative I see is using a macro to edit chart
properties after it finds the min/max values.

To add your standard line, simply copy the standard next to all the cells
used in first series, and add another series to the chart using these values.
Will create a flat line on your chart.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"First Aid Computing" wrote:

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

Unfortunately, it will only let me add vertical error bars instead of a
horizontal one. Will continue fiddling with this. However, all my data of
the last two weeks was lost as my office computer died while I was gone. Now
I have to wait for the computer to return and hope they didn't nuke the drive
as all inept techies are wont to do.

Hi,
The fact it will only let you add vertical error bars implies you have added
the data point as a line chart. Try selecting it and changing the chart type
to x-y scatter. then you should be able to add horizontal error bars. I can
email you an example if you want.

Dave

"First Aid Computing" wrote:

Unfortunately, it will only let me add vertical error bars instead of a
horizontal one. Will continue fiddling with this. However, all my data of
the last two weeks was lost as my office computer died while I was gone. Now
I have to wait for the computer to return and hope they didn't nuke the drive
as all inept techies are wont to do.