Sorting Bar Charts

[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.

 

[Barb Reinhardt]

Sort the chart how? Do you want a pareto?

 

[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/
_______