How to Make Nice Charts in Excel

Building a chart in Excel is easy, but making one that actually looks good and tells a clear story is another skill entirely. Default Excel charts are often cluttered, confusing, and fail to highlight the key insights hidden in your data. This guide walks you through the practical steps to transform your raw numbers into clean, professional, and persuasive charts that people will actually want to look at.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Start with a Solid Foundation: Clean Your Data

Before you even think about chart types or colors, the most important step happens in your spreadsheet. Great visualizations are born from well-organized data. A messy table will lead to a messy chart, so taking a minute to structure your data correctly will save you headaches later.

Keep Your Layout Simple and Predictable

Your data should be organized in a simple, tabular format. This means:

• Use a single header row: Put your categories or labels in the very first row (e.g., "Month," "Website Traffic," "Conversions").
• Data in columns: Each column should represent a distinct category or metric.
• No blank rows or columns: Empty rows or columns in the middle of your data can confuse Excel when it tries to select your data range automatically.

Here’s an example of a simple, clean data set ready for charting:

This simple structure makes it effortless for Excel to understand what you want to visualize.

Choose the Right Chart for the Job

Once your data is clean, the next big decision is picking the right chart type. Using the wrong chart is like trying to use a hammer to drive a screw - it might work, but it’s clumsy and ineffective. Your goal is to choose a chart that best tells the story in your data.

Bar and Column Charts: For Comparisons and Rankings

These are your go-to charts for comparing values across different categories. They are incredibly easy to read because our brains are great at comparing the length of bars.

• Use a column chart (vertical bars) when comparing a few categories, like sales performance by product.
• Use a bar chart (horizontal bars) when you have longer category labels that are easier to read horizontally, or when you have many categories to compare.

Ideal for: Comparing sales figures for different products, ranking marketing channels by lead generation, or showing survey results.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Line Charts: For Trends Over Time

If you're tracking a metric over a period (days, weeks, months, years), a line chart is your best friend. It instantly shows patterns, trends, and volatility.

Ideal for: Tracking monthly website traffic, daily sales numbers, or quarterly revenue growth over several years.

Pie Charts: For Showing Parts of a Whole

Pie charts show proportions - how different segments contribute to a total. However, use them with caution. The human eye isn’t very good at comparing the size of angles, making it hard to interpret if you have too many slices.

• Limit slices to 5 or fewer.
• Make sure the slices add up to 100%.
• If proportions are very similar, a bar chart is often a clearer alternative.

Ideal for: Displaying the percentage of traffic from different sources (e.g., Organic, Social, Paid) or the breakdown of a budget by department.

Scatter Plots: For Finding Relationships

A scatter plot is used to show the relationship between two different numerical variables. Each dot on the plot represents a single data point, allowing you to see if there's a correlation between the two variables.

Ideal for: Seeing if there's a connection between advertising spend and sales revenue, or between study hours and exam scores.

Step-by-Step: Creating and Customizing Your Chart

With clean data and the right chart type in mind, you’re ready to build. We’ll create a simple column chart and then refine it step-by-step.

Step 1: Select Your Data

Click and drag your mouse to highlight the cells containing the data you want to plot, including the headers.

Step 2: Insert the Chart

Go to the Insert tab in the Excel ribbon. In the "Charts" section, you’ll see icons for different chart types. A good starting point is the Recommended Charts button. Excel will analyze your data and suggest a few suitable options.

Alternatively, you can choose a specific type, like a column chart. Click the icon, and Excel will instantly generate a basic chart on your worksheet.

At this point, you have a functional - but probably unattractive - chart. Now comes the fun part: customization.

Graphed

Still Building Reports Manually?

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

Watch the Demo

The Art of Refinement: Making Your Chart Look Great

This is where you move from a data visualizer to a data storyteller. The goal is to remove unnecessary elements (clutter) and emphasize what’s important.

You can edit any element of the chart by clicking on it. When you click, a Chart Design and Format tab will appear at the top, and plus signs and paintbrush icons will appear next to the chart itself for quick edits.

1. Clear the Clutter Ruthlessly

Default Excel charts come loaded with elements that often distract from the main message. A clean chart is an effective chart.

• Remove gridlines: These horizontal lines are rarely necessary and just add visual noise. Click on a gridline and press the Delete key.
• Delete the legend (if it's redundant): If you’re only plotting one data series (e.g., "Revenue"), the legend is useless. Delete it. A good title can do its job instead.
• Simplify the axes: Are the thousands of dollars and cents on your Y-axis necessary? Right-click the axis, select "Format Axis," and adjust the "Display units" (e.g., to thousands) to make numbers cleaner.

2. Use Color with Intention

Color shouldn't just be decorative, it should serve a purpose. Default Excel colors are generic and uninspiring.

• Stick to a simple color palette: Use your brand’s colors for a professional look. If you don't have brand colors, pick one or two primary colors and use them consistently. Avoid using a different color for every bar.
• Highlight the important stuff: Make all your bars a neutral color (like gray) and then use a single, bold color to highlight the most important data point - like the month with the highest sales or the most recent quarter. This immediately draws your audience’s eye to the key takeaway.

3. Write A Clear, Story-Driven Title

The title is the most important piece of text on your chart. Don’t just describe the data, tell the story of the data.

• Boring title: "Monthly Sales"
• Good title: "Sales Bounced Back with 35% Growth in Q2"

A good title provides context and presents the main conclusion, meaning your audience instantly understands the chart's message without having to do the work of interpreting it.

4. Use Direct Data Labels

Instead of forcing your reader to move their eyes back and forth between the bars and the Y-axis, consider putting the values directly on the chart.

Click the '+' icon next to your chart and check the box for Data Labels. The values will appear on top of or inside your columns. This often makes the Y-axis itself unnecessary, allowing you to delete another piece of clutter.

Advanced Tips for Pro-Level Charts

Ready to take your skills a step further? These tricks can add another layer of polish and professional depth to your visualizations.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Create Combination Charts

Sometimes you need to visualize two different types of data on one handsome chart. For instance, you could show sales volume as a column chart and the average profit margin as a line chart. To do this, create a chart as usual, then right-click on one of the data series (e.g., the profit margin line) and select Change Series Chart Type. In the dialog box, you can assign different chart types and even plot one of the series on a secondary axis.

Add Trendlines

For line or scatter charts, adding a trendline can quickly show the overall direction of your data. Click the '+' icon and check Trendline. It's a simple way to instantly see if your numbers are generally heading up, down, or remaining flat.

Use Sparklines for Quick, In-Cell Visuals

Sparklines are tiny charts that live inside a single cell, perfect for visualizing a row of data without creating a full-blown chart. Say you have columns of monthly sales data for several different products. In a new column, you can insert a Sparkline (Insert > Sparklines > Line) that shows the sales trend for each product. It's an incredibly powerful way to embed visual context right next to your numbers.

Final Thoughts

Moving from a basic Excel chart to a "nice" one is less about technical skill and more about thoughtful design. It boils down to choosing the right visual for your story, then stripping away everything that isn't essential and using elements like color and text to guide your audience to the key insight. Once you master these principles, you'll be creating charts that don't just show data - they make a point.

This process of cleaning data, choosing charts, and designing visualizations can still take hours in a spreadsheet. At a certain point, manual reporting across different platforms just doesn't scale. That’s why we created Graphed. We connect directly to your data sources - like Google Analytics, Shopify, and your CRM - so you can skip the spreadsheet drudgery. Just ask a question in plain English, like "Show me a chart of my top 5 marketing channels by revenue last quarter," and we instantly build the perfect visualization for you in a real-time dashboard.