Plotting on Scatter graph

[VolvicRevolver]

Hello people,

I am hoping someone can give me some information as to where to start with a small problem I have. This may sound complicated but will try and keep it simple.

We have a special testing machine in the lab I work in, and it measures reflectivity from reflective vests etc. A special instrument takes a reflective reading and reports back a X and Y value which is used then as a co-ordinate and gets plotted on a graph.

The machine measures for 8 colours, and takes four readings, so for example the first color will be Flourescent Yellow. and then it produces 4 "X,Y" readings, which get plotted onto a graph, and joins all 4 points to create a box as shown in the link >> Graph with joined plots

This is a small capture of the spreadsheet with the values >> spreadsheet

Basically, I need to know how to take the values in columns X and Y, and then make it plot onto a graph as one point, and then join the four points for that one colour,

end result being the grapgh will have upto 8 boxes on it.

[shg]

Plot three different series in the usual way.

If you need help with workbooks, please post workbooks and not pictures.

[Andy Pope]

In order to close the polygon you will need to plot the first pair of values at the end of the series as well.

[VolvicRevolver]

I think i'm halfway towards what I need to do thanks to both replys.

I now have a scatter diagram, it's wrong lol.. but I will tinker with it more later on, just trying to get it to join each 4 sets of coordinates, where as all 8 * 4 sets are joined as one big mess!

Here is a sample of the worksheet btw

[Andy Pope]

I created the xy points for 2 series to the right of your original data.
The need to duplicate the start point, to enclose the polygon, made it more practical to stagger the sets of points in order to keep the references as simple as possible.

[VolvicRevolver]

Cool, I know where I went wrong now, I can't thank you all enough.

I have just been told I can ditch some of the unused data from the worksheet, but need to add in a 5th coordinate figure, which is an result figure, I have redesigned the sheet and got the graph to plot as "Andy" has done.

I now have a new problem. is there anyway I can hide a series of plots depending on a cell value is empty? ie, no number in a cell, then the series doesnt get shown,

I am assuming this has to be done using a IF statement or will it have to be done via a macro?

If it can be done using a IF statment, at which part of the worksheet does it need to go in?

[Andy Pope]

You can use a IF function on the X data values

So if the test cell is AB1 you can use this formula in AB5.

=IF(AB$1<>"",F5,NA())

If you repeat that for all the X values then the NA() will result in no points being plotted.

[VolvicRevolver]

Thanks again for your help.