I am attempting to do the following:
I have an excel driven organization chart imported into Visio with all shapes data linked to the excel spread sheet.
Currently the shapes are "colored by value" based on the "Geographic Location" column in Excel. There are certain shapes that have a special condition; example their geo. location is "DC**" the two "**" signifying that they are funded by a different pot of money and hence assigned a different color.
I have created a new column called "Funding" and for all the appropriate "**" instance and identified the funding source "Alternate" or "Regular" then changed "DC**" to just "DC".
I would like that all shapes be first colored by their "Geographic Location" and then by the "Funding" data field.