+ Reply to Thread
Results 1 to 3 of 3

Sorting Bar Charts

  1. #1
    LizW
    Guest

    Sorting Bar Charts

    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

  2. #2
    Barb Reinhardt
    Guest

    Re: Sorting Bar Charts

    Sort the chart how? Do you want a pareto?

    "LizW" <LizW@discussions.microsoft.com> wrote in message
    news:4FA67E35-A798-4724-8F8D-F43FD97DEF8D@microsoft.com...
    >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




  3. #3
    Jon Peltier
    Guest

    Re: Sorting Bar Charts

    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.


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1