Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
I will try your suggestion
I need to get Data Analysis installed. "Barb R." wrote in message ... 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 |
#4
|
|||
|
|||
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. |
#5
|
|||
|
|||
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
plotting a single line graph | New Users to Excel | |||
Plotting blank cells in line charts? | Charts and Charting in Excel | |||
How do I prevent Excel from plotting a cell w/ a formula as a "ze. | Charts and Charting in Excel | |||
How do I prevent Excel from plotting a cell w/ a formula as a "ze. | Charts and Charting in Excel | |||
Analyzing X,Y,Z coordinates of a chart | Excel Discussion (Misc queries) |