Dynamic Excel Grouping

GeoffreyJoseph

I have a spreadsheet that calculates dynamically based on user input. I would like to show the results on a map grouped with a natural break classification. Because the spreadsheet initially has no data in it, the breaks are very small. When the user adds data, the breaks can become quite large. My problem is that the grouping legend is not updated to reflect that (Population 65+ in the pic), and it causes some of the data to be 'Not Grouped. If I regroup then click "OK", it is updated (like population 18 to 64 in the pic). Is there a way to dynamically update the grouping when the spreadsheet is recalculated?

ScottBall

We've had discussions about this internally on the Maps for Office team. I agree that the ideal behavior would be to update the legend on data update. The concern is that implementing this behavior could create performance problems. We will continue looking at it and if we can do it, we will. Thanks for the feedback.