I have a 2d bar graph and want to sort from the lowest to the highest, the numbers are dynamic?
I have a 2d bar graph and want to sort from the lowest to the highest, the numbers are dynamic?
Not quite sure what you're getting at. Any chart will be ordered based on the relative size of the series values.
If the values are changing because they're dynamic and you still want an ordere by value series then you'll need to sort the series.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
This is a sample worbook. The values are not sorted from lowest to highest.
Those numbers aren't dynamic they are fixed. Neither have you sorted them.
Put a column label in J3 and onclude that in the sort range. At the moment you are ony sorting the bottom two values.
Thanks for your help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks