Sort data in an Excel chart
Solved
meredith-power
Posted messages
27
Status
Membre
-
rose -
rose -
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
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 réponses
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- 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
rose
Thank you, it's successful, but the data in the table should not be in formula form.
