Dynamically stacking columns by contribution

[samtwu]

I'm trying to create a stacked column chart that contains many stacked
elements. Y-axis is Volume, X-axis is time (say, month), and the
stacked elements are different products contributing to the overall
volume for the month. I'm interested in seeing each stacked column in
the order of largest to smallest contributor to volume for each month.
Thus, the stack order would change from month to month. I'm not
interested in whether the legend data series order matches the stack
orders (it can't since the series order on the stack columns change
from month to month). How could I do this?

Also, how do I selectively show which dataseries to show on a legend
without deleting the dataseries from the chart?

Thanks.

Sam

 

[Tushar Mehta]

In addition to messing up the legend, you will also have to deal with
messed up colors.

If the data for each month are in one column, then make a copy of the
data, using this copy sort each column *independently* of the others.
Now, plot these sorted columns.

For the second question: select the legend, pause, select the legend
you want to delete and delete it.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions