Sorting Bar Charts

L

LizW

I need to know the VBA code to sort bars in a chart. I am using a macro to
general a bar chart. I know we can sort the data and generate the bar chart
but would like to automate the process.

Thanks.
 
J

Jon Peltier

You can't sort the bars in the chart. You have to sort the data in the
chart's source data range. This is the action you need to automate.

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