How to Make a Salary Chart in Excel

Visualizing salary data in Excel is one of the fastest ways to understand compensation trends, identify potential inequities, and present clear insights to stakeholders. Manually scanning rows of numbers makes it nearly impossible to spot patterns, but a well-designed chart can tell a compelling story in seconds. This guide will walk you through creating several types of useful salary charts, starting with the basics and moving to more advanced visualizations for deeper analysis.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Why Bother Visualizing Salary Data?

Before jumping into the "how," let's briefly cover the "why." Putting your salary data into charts isn't just about making things look nice, it’s about making smarter, fairer business decisions. Visual analysis helps you:

• Identify Pay Gaps: Quickly see if there are significant salary discrepancies between roles, departments, or other employee categories.
• Understand Salary Ranges: See how compensation is distributed within a specific job title or pay grade. Are most people clustered at the bottom, middle, or top of the range?
• Analyze Department Costs: Compare the average or total salary costs across different departments to understand budget allocation.
• Spot Outliers: Easily identify salaries that are unusually high or low compared to the average, which might indicate a data entry error or a unique compensation situation worth reviewing.
• Communicate with Clarity: A chart is far more effective than a spreadsheet for presenting compensation data to leadership or HR teams during budget meetings or performance reviews.

Step 1: Preparing Your Data for Analysis

Your charts are only as good as the data you feed them. Before you start building visualizations, make sure your data is clean, organized, and properly formatted. An ideal dataset for salary analysis has clear, distinct columns.

Here’s a sample structure that works well:

Employee ID | Job Title | Department | Annual Salary 101 | Marketing Manager | Marketing | $95,000 102 | Sales Associate | Sales | $62,000 103 | Software Engineer | Engineering | $115,000 104 | Graphic Designer | Marketing | $71,000 ...and so on.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Best Practices for Data Prep:

• Use an Excel Table: Select your data range and press Ctrl + T (or Cmd + T on Mac) to convert it into an official Excel Table. Tables automatically expand to include new data, which means your charts will update dynamically as you add more employees.
• Format as Currency: Select the entire 'Annual Salary' column, right-click, choose "Format Cells," and select "Currency." This ensures your chart axes are clearly labeled with dollar signs and appropriate formatting.
• Check for Consistency: Make sure department names and job titles are consistent. "Sales" and "Sales Dept" will be treated as two separate categories, so use Find and Replace to standardize them.

How to Create Different Types of Salary Charts

Once your data is prepped, you can start building visualizations. We'll cover four effective chart types for salary analysis, from simple comparisons to nuanced distributions.

1. Simple Bar Chart: Comparing Individual Salaries in a Small Team

A bar chart is perfect for comparing salaries across a small number of employees or roles. It's direct, easy to read, and instantly shows who earns more or less relative to others.

When to use it:

Ideal for comparing salaries within a small team or for specific, distinct job titles.

Step-by-step instructions:

1. Select the columns containing the employee identifiers (like 'Job Title' or 'Employee ID') and their corresponding salaries. Hold the Ctrl key (Cmd on Mac) to select non-adjacent columns.
2. Navigate to the Insert tab on the Excel ribbon.
3. In the Charts section, click the Insert Column or Bar Chart icon.
4. Choose a 2-D Clustered Bar chart. A horizontal bar chart is often better for long labels like job titles.
5. Customize your chart:

2. Column Chart with PivotTable: Comparing Average Salaries by Department

What if you want to see the average salary for the entire Sales department versus the Engineering department? This requires aggregating the data first, and the easiest way to do this is with a PivotTable.

When to use it:

Perfect for comparing aggregate salary figures (like average, sum, or median) across different groups like departments, locations, or pay grades.

Step-by-step instructions:

1. Click anywhere inside your Excel Table.
2. Go to the Insert tab and click PivotTable. Excel will automatically select your table's range. Click OK.
3. A new sheet will open with the PivotTable Fields pane. Drag and drop the fields as follows:
4. By default, Excel will likely show "Sum of Annual Salary." To change this, click on the field in the Values area, select Value Field Settings, and choose Average. Format the number as currency in the same dialog box.
5. Now that you have your summary data, click anywhere inside the PivotTable.
6. Go to the PivotTable Analyze tab and click PivotChart.
7. Choose a Clustered Column chart and click OK.

You now have a clean column chart showing the average salary for each department, making comparisons simple and immediate.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

3. Histogram: Understanding the Overall Salary Distribution

A histogram is excellent for seeing how salaries are distributed across your entire organization. Does the company have a lot of low-earners and a few high-earners, or are most people clustered in the middle?

When to use it:

To view the frequency of salaries within certain ranges (or "bins"). It helps you see the shape of your compensation structure.

Step-by-step instructions:

1. Select your entire Annual Salary column (just the numbers, not the header).
2. Go to the Insert tab, click the Insert Statistic Chart icon (it looks like a small blue column chart).
3. Select Histogram and click OK.
4. Excel will automatically group the salaries into bins. You can customize these for more or less detail. Right-click the horizontal axis, choose Format Axis, and adjust the Bin Width (e.g., set to $10,000 to see salary groupings in $10k increments) or the Number of Bins.

This chart might reveal that most of your company's salaries fall between $60,000 and $90,000, with a few outliers on either end.

4. Box and Whisker Plot: Analyzing Salary Ranges and Quartiles

This is a more advanced but incredibly powerful visualization for compensation analysis. A box-and-whisker plot shows the distribution of a dataset, revealing the median, quartiles, and range all in one view.

When to use it:

Perfect for comparing salary distributions between different departments or seniority levels. It helps answer questions like, "Does the Marketing department have a wider salary range than the Engineering department?" or "Is the median salary for senior roles significantly higher?" A quick breakdown of what it shows:

• The box represents the middle 50% of salaries (the interquartile range).
• The line inside the box is the median salary (the middle value).
• The whiskers (lines extending from the box) show the range of the data, typically excluding outliers.
• Dots represent outliers - salaries that are unusually high or low.

Step-by-step instructions:

1. Arrange your data so you have one column for the category (e.g., Department) and another for the value (Annual Salary). Make sure all rows for a single department are grouped together.
2. Select both columns of data.
3. Go to the Insert tab > Insert Statistic Chart > Box & Whisker.
4. Excel will generate one plot for each department, placed side-by-side on the same chart, making it easy to compare their distributions.

This chart clearly illustrates not just the average pay, but the entire compensation structure for each group, providing a much deeper level of insight into pay equity and consistency.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Final Thoughts

With these methods, you can transform a plain spreadsheet of salary data into insightful, professional charts that support strategic decision-making. Whether you're using a simple bar chart to compare roles or a box-and-whisker plot to inspect pay equity, visualizing your data in Excel demystifies compensation and helps you build a fairer, more transparent organization.

Of course, manually building these reports in Excel takes time, especially if you need to combine payroll data with performance data from your HR system or sales commissions from your CRM. At Graphed, we automate the entire process for you. Instead of worrying about PivotTables and chart formatting, you can connect your data sources in a few clicks and ask questions in plain English like, "Create a column chart showing the average salary by department" or "What is the salary distribution for our Sales team?" We instantly build a live, interactive dashboard for you, saving you hours of manual work and helping you get to the insights that matter.