Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Showing the perimeter of a set of (X,Y) data!
Good day all,
I need to plot the perimeter of a set of data. I have a set of (X,Y) data with error bar and it is a nice mess so I just actually need to see (show) the area were the data can be found. Then hopefully overlay an other set of (X',Y') data and show that they both cover the same surface of existence. i.e this is a set of metrology measurement in X and Y of a part build from different mould. Obviously you get a nice cloud of X and Y but does the new material offer the same 'cloud' ? Thank you |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Showing the perimeter of a set of (X,Y) data!
I think the easiest way to do this is plot the data on a XY Scatter chart
(marker and no line). Now, format the marker to the smallest possible size. Optionally, you may want to fiddle with the color of the marker (just remember to set both the background and foreground) -- Tushar Mehta http://www.tushar-mehta.com Custom business solutions leveraging a multi-disciplinary approach In Excel 2007 double-click to format may not work; right click and select from the menu " wrote: Good day all, I need to plot the perimeter of a set of data. I have a set of (X,Y) data with error bar and it is a nice mess so I just actually need to see (show) the area were the data can be found. Then hopefully overlay an other set of (X',Y') data and show that they both cover the same surface of existence. i.e this is a set of metrology measurement in X and Y of a part build from different mould. Obviously you get a nice cloud of X and Y but does the new material offer the same 'cloud' ? Thank you |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Showing the perimeter of a set of (X,Y) data!
Andy Pope has a VBA procedure that may be just what you need.
http://www.andypope.info/charts/convexhull.htm Kelly O'Day http://processtrends.com wrote in message oups.com... Good day all, I need to plot the perimeter of a set of data. I have a set of (X,Y) data with error bar and it is a nice mess so I just actually need to see (show) the area were the data can be found. Then hopefully overlay an other set of (X',Y') data and show that they both cover the same surface of existence. i.e this is a set of metrology measurement in X and Y of a part build from different mould. Obviously you get a nice cloud of X and Y but does the new material offer the same 'cloud' ? Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Bar Chart with bar data and another bar showing a range of data | Charts and Charting in Excel | |||
Showing only rows with data | Excel Discussion (Misc queries) | |||
Data not showing on my chart | Charts and Charting in Excel | |||
New data in table not showing in graph | Excel Discussion (Misc queries) | |||
Bar showing value for missing data | Charts and Charting in Excel |