View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lear 6 sigma Guy Lear 6 sigma Guy is offline
external usenet poster
 
Posts: 1
Default How do I automatically populate a Pareto chart in sequence?

I can make a pareto in Excel. My problem is that As data is collected
throughout the month, The order changes in my table and I have to run a macro
to re-align the data every day. Is there a way (using a formula or a
template) to automatically sort the data into descending order?