Dear Excel Forum Members,

I have a question regarding the sorting out of graphs.

To my understanding (and from the relentless googling I've been doing), I haven't been able to find a way to sort out data for bar graphs to be from biggest to smallest. In other words, my graphs are currently created but the bars are of different sizes and are set up at random. I'd like them to be sorted out so that the first bar is the biggest and the last one is the smallest.

The only issue with this is that the data used for the creation of graphs has been gathered from various places in my workbook, and is dependent upon choices made in dropdown lists. (i.e. from the selections made the appropriate data will be gathered from a database sheet hiden in the workbook).

So I would like the graphs to constantly be in the appropriate order to matter what selections are made in the dropdown menus.

I am convinced that this should be VBA coding but can't quite work out how to do it.

Any help would be amazing. Thanks!