Help Plotting Cartesian Coordinates

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

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" wrote:

> 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
>
>
>

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




"Barb R." <BarbR@discussions.microsoft.com> wrote in message
news:746BBD47-6E3E-4E98-B867-8A5E7C91473C@microsoft.com...
>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" wrote:
>
>> 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
>>
>>
>>

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

Barb R. wrote:
> 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.
>

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


Gizzard wrote:
> 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)

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

In article <114glfsetibap3b@corp.supernews.com>, craigsie@hotmail.com
says...
> 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
>
>
>