my previous reply did work, for some reason you have to restart excel. Copy and past the data as values, then use this data for the map (i had a formula creating the column i wanted to map).
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.
Would you like to participate?