scatter plot colors/legend

I'm using Excel 2007.

I have three columns of data like this:

x y speed
1 5 90
5 -10 75
2 6 63

I have created a scatter plot with the x & y columns, but I want to color-code the points based on the speed. Of course, I'll need a legend to go with it.

Any ideas how to do this?

Thanks for your help.

Kevin

Hi Kevin,

there must be a way to do this and maybe this link gives you some inspiration:
http://www.ozgrid.com/forum/showthread.php?t=71562

If you still need more info, just post an example file and I will try to help you out.

J.