Value shading map issue

I am creating a map in Excel using MS Map to show a US
map. When using the value shading function, I can't
figure out how to keep the states that have no values
blank. What happens is the key shows a range of values (0-
10, 11-20). I need the states that have NO value to have
their own color (or lack of color) and I am not sure how
to do this...

Any suggestions?

Chris

In your data, you could calculate the state name in a new column, and
use the calculated name in the map. For example, if state names are in
column D, and values are in column E:

=IF(E2=0,"",D2)

The state name will appear blank if the value is zero.

Create the map using the value, and the calculated state name. When
prompted, choose to Disregard All.

The missing states will use the default fill colour, or you can select a
custom colour.

Chris wrote:
> I am creating a map in Excel using MS Map to show a US
> map. When using the value shading function, I can't
> figure out how to keep the states that have no values
> blank. What happens is the key shows a range of values (0-
> 10, 11-20). I need the states that have NO value to have
> their own color (or lack of color) and I am not sure how
> to do this...
>
> Any suggestions?
>
> Chris


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

But the range of my key gives "0-9%" as one color and I
need 0 to be it;s own color.

I am using vlookup to use a range. For example, if the
value is 15%, then it calls "11-20%."

So I would like the key to read as follows (words in
brackets would be the colors).

[white] none
[first shade] 1-10%
[second shade] 11-20%
etc...

any suggestions here? Can this be done?
>-----Original Message-----
>In your data, you could calculate the state name in a new
column, and
>use the calculated name in the map. For example, if state
names are in
>column D, and values are in column E:
>
> =IF(E2=0,"",D2)
>
>The state name will appear blank if the value is zero.
>
>Create the map using the value, and the calculated state
name. When
>prompted, choose to Disregard All.
>
>The missing states will use the default fill colour, or
you can select a
>custom colour.
>
>Chris wrote:
>> I am creating a map in Excel using MS Map to show a US
>> map. When using the value shading function, I can't
>> figure out how to keep the states that have no values
>> blank. What happens is the key shows a range of values
(0-
>> 10, 11-20). I need the states that have NO value to
have
>> their own color (or lack of color) and I am not sure
how
>> to do this...
>>
>> Any suggestions?
>>
>> Chris
>
>
>--
>Debra Dalgleish
>Excel FAQ, Tips & Book List
>http://www.contextures.com/tiptech.html
>
>.
>