If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
map created in Excel 2000
I have a user who created a report a few years ago.
Basically what it boils down to is that it uses a US map and each state is color coded to reflect a certain range of data. Such as.. let's say the number of college grads per capita in one state is 900, then maybe that state shows as red b/c a range of 850 to 949 is designated by red. Maybe a range of 750-849 is designated by pink and so on down (and up) the line. Apparently this was a function that she stumbled across in Excel 2000 but she doesn't seem to be able to locate it in 2002 and I can't seem to figure it out either. Any help is MUCH appreciated b/c it was an impressive looking chart. Thanks! |
#2
|
|||
|
|||
map created in Excel 2000
Excel 2002 doesn't include the map tool. However, if you still have your
Excel 2000 disks, you can try the tip on this page: Getting What's Missing in Excel 2002 http://www.winplanet.com/winplanet/tips/3997/1/ Christina wrote: I have a user who created a report a few years ago. Basically what it boils down to is that it uses a US map and each state is color coded to reflect a certain range of data. Such as.. let's say the number of college grads per capita in one state is 900, then maybe that state shows as red b/c a range of 850 to 949 is designated by red. Maybe a range of 750-849 is designated by pink and so on down (and up) the line. Apparently this was a function that she stumbled across in Excel 2000 but she doesn't seem to be able to locate it in 2002 and I can't seem to figure it out either. Any help is MUCH appreciated b/c it was an impressive looking chart. Thanks! -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Thread Tools | |
Display Modes | |
|
|