I have a large spreadsheet I create weekly charts from. There are 30 some odd column headers that are static and the data for those columns are filled in daily.
Once a week I create a chart of the "Top 10" from those 30 columns worth of data. I would like that chart to be a Clustered Column Chart in decending order showing the top 10 heavy hitters for the week (with the column headers from my worksheet being the X axis and the number of occurances being the Y axis). I can do this with a lot of copy/paste of the data I already have and then sorting it, but it seems ridiculous and the long, long way of doing it.
Does anyone have any suggestions on how to do what I am talking about? Am I making sense with my description?