Re: Value shading map issue
From: Debra Dalgleish (dsd_at_contexturesXSPAM.com)
Date: 02/09/04
- Next message: Bernard Liengme: "Re: Why hasn't MS fixed this yet.....?"
- Previous message: Debra Dalgleish: "Re: Leader lines on charts"
- In reply to: Chris: "Value shading map issue"
- Next in thread: anonymous_at_discussions.microsoft.com: "Re: Value shading map issue"
- Reply: anonymous_at_discussions.microsoft.com: "Re: Value shading map issue"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 09 Feb 2004 18:07:29 -0500
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
- Next message: Bernard Liengme: "Re: Why hasn't MS fixed this yet.....?"
- Previous message: Debra Dalgleish: "Re: Leader lines on charts"
- In reply to: Chris: "Value shading map issue"
- Next in thread: anonymous_at_discussions.microsoft.com: "Re: Value shading map issue"
- Reply: anonymous_at_discussions.microsoft.com: "Re: Value shading map issue"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
