Help Plotting Cartesian Coordinates

[Gizzard]

I would like to chart this columular data on a cartesian graph.

This data produced by a coordinate measuring machine measuring a hole
position.

The nominal axes are X = 26.85 and Y = -3.85.

This information will provide a graphical view of process repeatability.



C_1.X C_1.Z

26.843 -3.864

26.865 -3.875

26.88 -3.872

26.839 -3.847

26.848 -3.839

26.812 -3.845

26.87 -3.872

26.842 -3.873

26.84 -3.878

26.809 -3.867

26.842 -3.845

26.888 -3.895

26.808 -3.853

26.881 -3.831

26.856 -3.821

26.861 -3.806

26.882 -3.798

26.858 -3.816

26.887 -3.788

26.904 -3.845

26.87 -3.796

26.901 -3.793

26.867 -3.809

26.85 -3.802

26.857 -3.783

26.913 -3.793

 

[Barb R.]

I would think that a histogram of both the X and Y coordinate with the spec
limits (if available) would be useful. Alternatively, maybe a control chart
of the same data would be useful. As I understand your question, you'll
have a whole lot of points plotted in a small area on the chart.

 

[Gizzard]

I will try your suggestion
I need to get Data Analysis installed.

 

[redbelly]

Historgrams are useful, but would not show if there is any correlation
between the two variables (i.e., does one "track" with the other?). An
XY chart would show this.

The points need not be in a small area, it depends how the axes are
scaled. For example, x-axis limits of 26.80 to 26.92, and y-axis
limits of -3.90 to -3.78, would work.

Mark

 

[redbelly]

It's pretty difficult to completely explain how to make an Excel Chart
in here. Probably best for you to look at an Excel book -- there are
many of them at Borders books, Barnes and Noble, etc.

How familiar are you with Excel? I mean, can you import the numbers
into the spreadsheet? Have you any experience with making Excel
charts? It would need to be an XY(Scatter) Chart Type.

Mark

I would like to chart this columular data on a cartesian graph.

This data produced by a coordinate measuring machine measuring a hole

position.

The nominal axes are X = 26.85 and Y = -3.85.

This information will provide a graphical view of process repeatability.

(snip)

 

[Tushar Mehta]

Put the x and z data in two adjacent columns. Select any cell in that
range, click the Chart wizard button. In the first step, select the XY
Scatter chart. Click Finish (for a first attempt you can safely skip
the remaining steps).

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions