Good morning all,

Attached is a snapshot of part of a vineyard mapped out on one sheet and data relating to that vineyard on another.
I am Really struggling to work out how to show the various ailments of a particular vine on the map. My first thought was a simple conditional format so; if a vine had 'red leaf' and that was logged against the vine, it would show red on the map sheet. However, what happens when a vine has red leaf AND another condition, shown in a different column. When you view the sheet you will understand what I mean.
The objective s to be able to look for patterns in the data, or how an ailment is trcking across the vineyard.
I considered havng a seperate 'map' sheet for each bit of data but this will not allow the layered view I was hoping for.
If this is possible somehow I also wondered whether a 'filter' would be able to be used on the map, so that i can select which ailments are shown.
Any help gratefully received as I am supposed to present this data to the bosses by tomorrow ! Thank you

On Tuesday, August 14, 2012 4:29:50 AM UTC-5, Rob Lewis wrote:
Good morning all,



Attached is a snapshot of part of a vineyard mapped out on one sheet and

data relating to that vineyard on another.

I am Really struggling to work out how to show the various ailments of a

particular vine on the map. My first thought was a simple conditional

format so; if a vine had 'red leaf' and that was logged against the

vine, it would show red on the map sheet. However, what happens when a

vine has red leaf AND another condition, shown in a different column.

When you view the sheet you will understand what I mean.

The objective s to be able to look for patterns in the data, or how an

ailment is trcking across the vineyard.

I considered havng a seperate 'map' sheet for each bit of data but this

will not allow the layered view I was hoping for.

If this is possible somehow I also wondered whether a 'filter' would be

able to be used on the map, so that i can select which ailments are

shown.

Any help gratefully received as I am supposed to present this data to

the bosses by tomorrow ! Thank you





+-------------------------------------------------------------------+

|Filename: data.jpg |

|Download: http://www.excelbanter.com/attachment.php?attachmentid=534|

|Filename: map.jpg |

|Download: http://www.excelbanter.com/attachment.php?attachmentid=535|

+-------------------------------------------------------------------+







--

Rob Lewis

Might be easier if you attach EXCEL file