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