Stacked Column VBA

[trickdos]

I am trying to sort the columns so that the largest value is on th
bottom each year. This would change the order of the series over eac
year presumably. I have not figured out a way to do this, and i
probably can be done with VBA. Any ideas? Thanks.

I attached the file for viewing

Attachment filename: testbook_stackedcols.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=61644

 

[Jon Peltier]

Do you want each stack to be sorted? This is rather complicated. There
was an extensive thread in the charting group this spring which
discussed just this problem. You could check the archives at
http://www.google.com/advanced_group_search, and look for Tushar Mehta's
name, because he was active in that one.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______