Another possibility (although it may be impractical for your application) is
to add the new values by inserting rows into the middle of the category,
rather than at the end. This should have the effect of expanding the formula.

Art