How to Show Top 10 in Excel Chart

Showing an entire data set in a single chart can be overwhelming, making it hard to spot what’s most important. Highlighting your top 10 performers - whether it's products, salespeople, or marketing campaigns - quickly focuses the conversation on the biggest drivers of your business. This tutorial will walk you through a few different ways to create a Top 10 chart in Excel, from a simple, static method to a fully dynamic and interactive approach.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Why Bother with a Top 10 Chart?

In data analysis, clarity is king. A chart with 50 different bars is more of an eye test than a useful insight. Isolating your top performers helps you:

• Focus on Impact: Identify the 20% of your efforts that are driving 80% of the results, a concept known as the Pareto principle. Are a handful of products generating most of your revenue? Are a few keywords bringing in most of your website traffic?
• Reduce Noise: When you remove the clutter of low-performing items, the key trends become instantly visible. It makes your reports cleaner and easier for stakeholders to digest quickly.
• Make Better Decisions: By knowing what works best, you can decide whether to double down on your top performers, apply lessons from them to other areas, or investigate why some items outperform others so significantly.

Creating this focused view is a common task, but Excel doesn’t have a simple "Show Top 10" button on its standard charts. Not to worry - we'll create our own with a bit of data prep.

Method 1: The Quick and Easy Sort & Filter

This is the fastest method, and it's perfect for one-off analyses or situations where your data doesn't change frequently. You simply filter your data to show only the top 10 entries before creating the chart.

Let's use a simple dataset of book genres and their monthly sales as an example.

Step-by-Step Instructions:

1. Select Your Data Header: Click on any cell in the header row of your data (e.g., "Genre" or "Monthly Sales").
2. Add Filters: Go to the Data tab on the Ribbon and click the large Filter icon. A small dropdown arrow will appear next to each column header.
3. Apply the Top 10 Filter:
4. Configure the Filter: In the pop-up window, you can customize the filter. The defaults are already set to "Top" and "10" "Items," which is exactly what we need. You could also change this to find the Bottom 5, Top 20%, etc. Click OK.

Your table will now only display the rows for the top 10 selling genres.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Step 5: Create Your Chart

With your data filtered, just create a chart as you normally would. Select the visible data, go to the Insert tab, and choose your preferred chart type. Excel is smart enough to only chart the visible, filtered cells.

Heads Up: The main downside to this method is that it’s static. If you add new data or update existing sales figures, you’ll need to clear the old filter and re-apply it to see the new top 10. For reports that need regular refreshing, Method 2 or 3 is a better fit.

Method 2: Creating a Dynamic Chart with a PivotTable

For data that changes or updates, a PivotTable is your best friend. It’s arguably the most efficient and powerful way to build a Top 10 chart in Excel because it does all the heavy lifting for you and updates with a single click. No formulas needed!

Step-by-Step Instructions:

1. Insert a PivotTable: Click anywhere within your source data table. Go to the Insert tab and click PivotTable. Excel will likely guess your data range correctly. Choose to place it in a new or existing worksheet and click OK.
2. Build the PivotTable: In the "PivotTable Fields" pane on the right:

You should now have a simple summary table showing the total sales for each genre.

Step 3: Apply the PivotTable's "Top 10" Filter

This is where the magic happens. A PivotTable has the same filtering capability we used before, but it's integrated directly and remains active even when the data updates.

• Click the dropdown arrow next to "Row Labels" in cell A3 of your PivotTable.
• Select Value Filters, then Top 10...
• The same dialog box from Method 1 appears. Check that it's set to "Top 10 Items by Sum of Monthly Sales" and click OK.

The PivotTable instantly updates to show only the top 10 genres. The best part? If you change your source data, just right-click the PivotTable and hit Refresh to get the new Top 10 automatically.

Step 4: Insert a PivotChart

Now, let's turn this dynamic table into a dynamic chart.

• Click anywhere inside your filtered PivotTable.
• Go to the PivotTable Analyze tab on the Ribbon (this tab only appears when a PivotTable cell is selected).
• Click PivotChart. Choose a chart type (like a Column or Bar chart) and click OK.

This chart is directly linked to your PivotTable. Anytime the PivotTable updates, the chart updates with it. You now have a fully dynamic, automatically-refreshing Top 10 chart.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Method 3: The Power User Formula Approach (Microsoft 365)

If you have Microsoft 365, you have access to powerful new formulas like SORT and FILTER that can create dynamic arrays. This method offers the ultimate flexibility without needing a PivotTable. It's perfect if you want to include dynamic results within a pre-formatted dashboard layout.

The Goal: The Dynamic Duo of SORT and FILTER

We'll write a single formula that finds the top 10 items, sorts them in descending order, and spills the results into your desired cells. The results update instantly as your source data changes.

First, make sure your source data is in an official Excel Table for easier formula referencing. Select your data and press Ctrl + T, then give your table a descriptive name in the Table Design tab (e.g., "SalesData").

The Formula:

Find a blank area on your sheet where you want the Top 10 list to appear. In the top-left cell of that area, enter this formula:

=SORT(FILTER(SalesData, SalesData[Monthly Sales]>=LARGE(SalesData[Monthly Sales],10)), 2, -1)

Breaking Down the Formula:

Let's unpack that from the inside out. It looks complex, but each piece has a simple job.

1. LARGE(SalesData[Monthly Sales], 10) This part is the threshold calculator. It looks through the "Monthly Sales" column of your 'SalesData' table and finds the 10th largest number. For example, if the 10th largest sale is $5,000, this formula returns 5,000.
2. FILTER(SalesData, SalesData[Monthly Sales]>=...) The FILTER function does the selecting. It looks at the entire 'SalesData' table and keeps only the rows where the "Monthly Sales" value is greater than or equal to the 10th largest number we just found. This gives us our top 10 entries (plus any ties).
3. SORT(..., 2, -1) Finally, the SORT function takes the filtered results and organizes them. We tell it to sort by the 2nd column (Monthly Sales) in descending order (that's what the -1 does). This gives us a nice-looking chart from largest to smallest.

Once you press Enter, Excel will "spill" the results into the cells below and to the right, creating a live, dynamic list of your top 10 performers.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Create the Chart

The downside of a dynamic array is that you can't include it directly in a chart's source data range since the range could change. To fix this, you add a # symbol to the end of the first cell reference where you entered the formula.

1. Insert a chart as usual (Insert > Chart). It will be blank initially.
2. Right-click the chart and choose Select Data.
3. Under "Legend Entries (Series)," click Add.
4. In "Series values," select the spilled sales data by clicking on the first sales value in your dynamic list and adding a # to the end of the cell reference (e.g., Sheet1!$D$2#).
5. Click Edit under "Horizontal (Category) Axis Labels" and select the spilled genre names, remembering to add a # to this reference as well (e.g., =Sheet1!$C$2#).

Now your chart is connected to the dynamic array and will automatically resize and update as your Top 10 list changes.

Bonus Tip: How to Show a Combined "Others" Category

Sometimes, showing only the Top 10 feels incomplete. What if you want to compare their performance to everything else combined? Creating an "Others" category gives you the full picture.

1. Calculate Your Top 10 Values: Use either the PivotTable method or the dynamic formula method to get your top 10 list in a helper table.
2. Calculate "Others": In the row immediately below your top 10 list, type "Others". In the cell next to it, use a simple formula to calculate the remaining value:
3. Create a Chart from the New Table: Select your new table (which now includes the top 10 items plus the "Others" category) and create a chart. A Pie or Doughnut chart works particularly well here to show part-to-whole relationships.

This technique shows stakeholders a perfectly balanced view - highlighting the key drivers while still accounting for 100% of the data.

Final Thoughts

Moving from a cluttered chart of all your data to a focused Top 10 summary is one of the quickest ways to make your reports more professional and insightful. You can get started with a simple filter, or create a fully automated dashboard using the power of PivotCharts or modern array formulas for a solution that lasts.

While mastering these techniques is incredibly powerful, we realized much of this manual setup can be automated. At Graphed , we’ve created a way for you to simply connect your sales and marketing data, and then ask for what you need in plain English. You can literally type "show me a bar chart of my top 10 campaigns by revenue for the last 30 days," and instantly get a live-updating dashboard, letting you spend more time on strategy and less on building reports.