Thread: Ploting graphs with constrictions

Hi there,

I would like to build a macro that plots data according to some specific constrictions. I have attached an example of what the file I am using looks like.

The idea is that I need to make multiple plots of x,y coordinates depending on whether or not a certain number fits within a certain range. If you open the file you will see that the in column A the left two digits are separated by a " - ". These 2 digits represent an aisle within a facility and can be a # anywhere from 1-99 or the following letters DO,ST and TW.

Now, the first sheet holds a table in which the minimum and maximum aisle will be inserted manually. From there I need to make a plot for all the aisle numbers that fit within each section. and then a separate plot for each of DO, ST and TW .

So:

I need to make a plot for each range of aisle values

And:
I need to make a plot for all the rows that have column B defined as "S"
A plot for all the rows that have column B defined as "R"

Thanks, for the help!

This is only my 4th macro so bare with me!



I am having trouble uploading the excel file, I'll kee trying meanwhile here is some of the data:

LOCATION CAT DESC WID DEP POS HGT POS HGT X Y Z
01-2472 S SF 101 61 1 60 0 0 10092 11631 26
01-2473 S SF 234 61 1 60 0 0 10092 11646 26
01-2474 S SF 122 61 1 60 0 0 10092 11662 26
01-2475 S SF 121 61 1 60 0 0 10092 11677 26
01-2476 S SF 120 61 1 60 0 0 10092 11692 26
01-2477 S SF 102 61 1 60 0 0 10092 11707 26
01-2478 S SF 122 61 1 60 0 0 10092 11723 26
01-2479 S SF 103 61 1 60 0 0 10092 11738 26
01-2611 S SF 122 102 200 183 0 0 10092 11753 26
01-2612 S SF 122 61 1 60 0 0 10092 11768 26
01-2613 S SF 62 61 1 60 0 0 10092 11783 26
01-2614 S SF 102 61 1 60 0 0 10092 11799 26
01-2615 S SF 61 61 1 60 0 0 10092 11814 26
01-2616 S SF 109 61 1 60 0 0 10092 11829 26
01-2617 S SF 102 61 1 60 0 0 10092 11844 26
01-2618 S SF 122 61 1 60 0 0 10092 11860 26
01-2631 S SF 53 61 1 60 0 0 10092 11875 26
01-2632 S SF 102 61 1 60 0 0 10092 11890 26
01-2633 S SF 122 61 1 60 0 0 10092 11905 26
01-2634 S SF 55 61 1 60 0 0 10092 11921 26
01-2635 S SF 53 61 1 60 0 0 10092 11936 26