Interesting solution Andy. Too bad there isn't a way to keep the totals at the bottom, or some way to exclude totals from the color shelf. But then I guess you wouldn't have to do this workaround. --Shawn
You're right - it would be nice to have a default way of making totals ignore the colour solution. Another way of keeping totals at the bottom is to fudge things with multiple worksheets, correctly aligned, on a dashboard. this is risky though because your data might change shape and the alignment will go out of whack.