How to Sort Chart in Excel from Highest to Lowest

Having your Excel chart automatically arrange values from highest to lowest makes your data instantly easier to understand. This simple ordering helps your audience immediately spot top performers, key trends, and important outliers without having to squint at the details. We'll show you exactly how to sort your chart data, why it works, and how to handle a few common scenarios you might encounter.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Why You Can't "Sort" an Excel Chart Directly

Here’s the first thing to understand: Excel charts are visual representations of your underlying source data. You don’t sort the chart itself, you sort the table or range of data powering the chart. Once you rearrange the data in your worksheet, the chart will automatically update to reflect that new order.

Think of it like arranging books on a shelf by height. You physically move the books (your data), and the visual result is a neatly ordered shelf (your chart). Understanding this relationship is a really helpful concept in Excel charting and dashboarding.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Step-by-Step Guide: How to Sort a Chart in Excel

Let's walk through the most common scenario: sorting a simple bar or column chart to show the highest values first. We'll use a basic dataset of product sales as our example.

Imagine you have this data in your spreadsheet:

Example Data Table:

• Column A: Product Name
• Column B: Units Sold

You’ve already created a column chart from this data, but the bars are in a random order based on how they were entered, making it difficult to see which product is the bestseller at a glance.

To fix this, we need to arrange all the products from the highest 'Units Sold' number down to the lowest. Let’s sort this out:

Step 1: Select Your Data Range

The most important step is to select your entire data table - not just the column you want to sort by. If you only select the 'Units Sold' column, Excel will sort those numbers without moving the corresponding 'Product Name' labels, completely scrambling your data.

Click and drag to highlight all the cells in your table, including the headers ("Product Name" and "Units Sold").

Step 2: Open the Sort Dialog Box

With your data selected, go to the Data tab on the Excel ribbon. In the Sort & Filter group, click the large Sort icon. This will open the Sort dialog box, which gives you precise control over how your data is organized.

Quick Tip: Don't use the small 'AZ' (Sort A to Z) or 'ZA' (Sort Z to A) buttons for multi-column tables. These quick-sort buttons often only sort by the leftmost column, which isn't always what you want. The main Sort dialog box is safer and more flexible.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Step 3: Define the Sorting Rules

The Sort dialog box is where you tell Excel exactly how to rearrange your data. Here’s what to look for:

• My data has headers: Ensure this box is checked if your selection included the header row (e.g., "Product Name", "Units Sold"). This tells Excel to exclude the first row from the sorting process. If you didn't include the headers in your selection, leave this unchecked (Excel will refer to them based on column letter).
• Sort by: Click the dropdown and select the column you want to sort by. In our case, we want to sort by sales volume, so we’ll choose "Units Sold."
• Sort On: Leave this as "Cell Values," as we are sorting based on the numbers in the cells.
• Order: This is where you specify the direction. To show the highest values first, select Largest to Smallest. (If you were sorting alphabetically, you'd see "A to Z" or "Z to A," for dates, you'd see "Oldest to Newest".)

After setting these options, click OK.

Step 4: Check Your Updated Chart

And that’s all there is to it. Once you confirm the sort, your data table will reorder, and your chart will immediately update to match. The bars will now be arranged in descending order, with the product that sold the most units appearing first.

Sorting Charts Based on an Excel Table

For more dynamic and scalable reports, it's highly recommended to convert your data range into an official Excel Table before you even create your chart. This offers several advantages, especially for sorting.

Why Use an Excel Table:

• Easy Sorting: Tables come with built-in filter and sort arrows in the header row. No need to go to the Data tab.
• Dynamic Range: When you add new rows or columns to your table, any charts based on that table automatically update to include the new data. You don’t have to manually adjust the chart’s source data.

Here’s how to do it:

1. Select your data range.
2. Go to the Insert tab and click Table (or use the shortcut Ctrl + T).
3. Ensure the "My table has headers" box is checked, and click OK.
4. Your range will now be formatted as a table, complete with alternating row colors and filter dropdown arrows in each header.

Now, to sort your chart, simply click the dropdown arrow on the header of the column you want to sort by (e.g., "Units Sold") and select "Sort Largest to Smallest." Both the table and the chart will update instantly.

How to Handle Sorting for Different Chart Types

While sorting works great for bar and column charts, the approach differs slightly for other chart types.

Sorting a Pie Chart

Like a bar chart, pie charts benefit from sorting as well, as it arranges the slices logically from highest to lowest. Again, sort the data - from largest to smallest value. This will create larger and more dominant slices and help highlight the most important data.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Sorting a Line Chart

It is not recommended to sort on this type of chart as line charts typically show trends over time, hence date ordering (e.g., month over month). Altering the x-axis order may be a bad choice. However, in one specific situation, you may want to sort categories by their latest value. Simply sort your source data based on the values in the last column or row. As usual, your chart will be updated accordingly to the sorting.

Final Thoughts

Organizing your chart data from highest to lowest is a fundamental step in creating clear, impactful data visualizations in Excel. By remembering that you're sorting the source data table - not the chart itself - you can quickly rearrange any bar, column, or pie chart to tell a more compelling story and guide your audience to the key insights. We turn this manual sorting and reporting grind into a conversation. Instead of manipulating rows in a spreadsheet, you can simply connect your data sources to Graphed and ask for what you need - for instance, "Show me my product sales as a bar chart, sorted from highest to lowest." We instantly build a live, interactive dashboard for you, so you can spend less time wrestling with settings and more time acting on what your data is telling you.