00:00I recently published an excel tip on how to dynamically highlight your bar chart
00:03based on the country you have selected but someone on the comment section had
00:07asked how do we actually change the order of this bar chart in descending order
00:13for this instance how do you move the largest bar chart right at the top well
00:17basically there's two ways to do it method number one would be to sort your
00:20data type you select your data type table here and then you go
00:24data sort and filter you press a to z it will sort the chart into descending
00:31order if you want ascending order you do z to a like that and you will flip it
00:35let me undo everything twice like this and the second method would be to
00:40actually change the y-axis let me demonstrate how you can do it
00:44you select and right click the y-axis data like this and then you go to
00:49format axis this will open a side menu here make sure you're selected to
00:54axis options here in here you'll be selecting at maximum category
00:58and put a check on category in reverse order there you can see it
01:02we have just flipped the bar chart in descending order without sorting the
01:05source data table
Comments