Excel Chart

[Jim]

Hello,

I'm trying to create a chart in Excel and am having
difficulties. I'd like to know if anybody has any ideas
if this is possible and how to do it.

My data consist of single measurement readings and the
measurement time from each part produced from a set of 20
molds. The set of molds are in continous production and
parts from each mold are measured multiple times per day.
I'd like to make a chart that uses the measurement time
stamp along the X axis and the mold numbers along the Y
axis. In the body of the chart, I want to put a point
(measurement value or symbol) that aligns with the mold
number and the appropriate measurement time.


data example:

Mold# Value Time stamp
1 25 13:00
2 24 13:07
3 25.3 13:42
2 24.7 14:00
1 22.0 14:12
1 23.0 14:23
3 22.8 14:56

Desired graph:



3 | X X
|
2 | X X
|
1 | X X X
|________________________________________________
13:00 13:07 13:42 14:00 14:12 14:23 14:56

Instead of the X, the actual data value could be inserted.

Thanks to all in advance,

Jim

 

[Guest]

Jim

Put your time reading (x-axis) in one column, then your measurement in the next column to the right (y-axis). Highlight all the data, click on chart wizard, select XY Scatter plot, then select point plot. If you input your time in h:mm format, the chart axis will display the same

time measuremen
1:07
2:18
4:02

John