Dynamic Legend sorting by values in Excel

My graphed data has about 80 legend entries and I'm only interested in displaying the ones with the highest values attached.

Is there a way to do this in Excel 2010? Manual sorting is not a question, as the graph is operating on a dynamic range.

EDIT: After trying this, along with all the included troubleshooting comments, I still can't find a way of a dynamic legend. Moreover I got dv'd for almost no reason (no comment + dv -> not much help)


Using Python and not Excel is somewhat of an answer. Still interested if this is possible in Excel at all, but it doesn't look like it from my research + community response or should I say lack thereof.

Need Your Help

Differences between WifiConfiguration status

android android-4.0-ice-cream-sandwich android-wifi android-4.2-jelly-bean wificonfiguration

What is the difference between WifiConfiguration.Status = CURRENT and ENABLED? I can figure for DISABLED but the difference between CURRENT and ENABLED is not obvious to me.

PHP version 5.2.3 and Twilio, issues with sending SMS

php sms twilio

I'm having a bit of trouble sending SMS on my web application using PHP Version 5.2.3 (I have been asked not to update the version).