Charting Text

[MFC]

Below sample data I am trying to chart but I'm not sure if Excel can do this.
It is basically a record of animals (tags) and where they have been spotted.

I am trying to create a chart (maybe a scatter) with Location and Month on
the X & Y axis and the tag data to appear to show a sighting. I have created
a work around using a pivot table but the person looking at this chart is not
an Excel user and I want to keep it simple.

Any suggestions?

Location Month Tag
NW Jan J33
NW June J34
SW May J33
SW June J35
E Oct J36
E Nov J35
W May J33
W Apr J34

 

[MFC]

Thank you Dave,

I will try your solution. I would be grateful if you could email the file
to me. What is the best way to give you my address ?

 

[Shane Devenshire]

Hi,

Please keep your threads together, starting a new thread for every response
makes it very difficult for us to follow.

Cheers,
Shane Devenshire