Thank you John, I appreciate the response; I have not used =large before and
have looked at help on the function; however, I'm not clear as to how you are
suggesting I use it to have it do the sort?? Thanks!
--
Marv Lusk
Boise Corporation


"Jon Peltier" wrote:

Use an intermediate range for the chart source which links to the real data
but uses large() to provide the sorting.

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


"MarvInBoise" wrote in message
...
I have a chart that updates using a total line; values change daily and
update the totals; I would like the chart to display left to right/high to
low and I cannot sort the total/sum line to cause the chart to display
this
way; is there a way I can do this? It is a column chart. Thank you!
--
Marv Lusk