GIS problems (MAPS)

Hi all.

I have the requirement to buid a lot of maps using BEX

Analyzer (Excel).

The problem is that depending on the query selections, the range that compound the legends will change.

For example :

In the selection screen I have two characteristics :

0_region (static geo) and 0_customer.

If I fill the 0_customer with 1000, the range to shade the map will be :

0 to 100 - red

100 to 200 - green

If I fill the 0_customer with 200, the range to

shade the map will be another:

0 to 1000 - blue

1000 to 10000 - brown

I would apreciate if someone could help me with any sugestions in creating these legends dinamically.

Regards

esilber