Sorting Bar Charts

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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/
_______
 
Back
Top