C
Chris
Currently I work in sales and Microsoft Map in Excel is a
great tool. However I ran into the problem with ranging.
Currently the Map only lets you select an equal number of
set items or a equal spread of values. My sales range can
be from $1 to 1.4 million. If I use equal spread, it
breaks it into threes.....if I use equal number the range
is way off, i.e. 10-20, 20-30, 40-50. then like 90-
1.1million, no matter how many value ranges I add. And
the sales amounts are constantly changing. Am I stuck?
In other words, why isn't the range like 0-50,50-100,
etc... why does it produce so many small ranges then one
large?? Am I just going to have to accept this?
great tool. However I ran into the problem with ranging.
Currently the Map only lets you select an equal number of
set items or a equal spread of values. My sales range can
be from $1 to 1.4 million. If I use equal spread, it
breaks it into threes.....if I use equal number the range
is way off, i.e. 10-20, 20-30, 40-50. then like 90-
1.1million, no matter how many value ranges I add. And
the sales amounts are constantly changing. Am I stuck?
In other words, why isn't the range like 0-50,50-100,
etc... why does it produce so many small ranges then one
large?? Am I just going to have to accept this?