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.
--
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.
--
LizW
Sort the chart how? Do you want a pareto?
"LizW" <[email protected]> wrote in message
news:[email protected]...
>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.
> --
> LizW
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/
_______
LizW wrote:
> 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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks