Sort data in an Excel chart

Solved
Hello,

Is there a way to sort the data in ascending or descending order in my bar chart?

Thank you!

Configuration: Mac OS X 10.6.4

8 answers

  • Votes
  • Date
  • Descending date
  1. I used a simpler solution:

    1- Select your source table
    2- From the "Home" tab, click on "Format as Table" (choose the style you want - it doesn't matter)
    3- Now at each column header, it is possible to sort the data in ascending/descending order, which directly impacts your chart.
    4- It's done ;)

    Ghostk
    1. Thank you, it's successful, but the data in the table should not be in formula form.