Value shading map issue

[Chris]

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]

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.

 

[Guest]

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?