How to Format Graphs in Excel

Creating a graph is the easy part of Excel analysis, but turning that basic visual into a clear, persuasive, and professional-looking chart requires thoughtful formatting. A well-formatted graph can make your data story resonate, while a cluttered one can confuse your audience. This guide will walk you through the essential steps to format graphs in Excel, transforming them from default outputs into compelling data visualizations.

Graphed

Still Building Reports Manually?

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

Watch the Demo

First, Choose the Right Chart for Your Data

Before you touch any of the formatting tools, the most critical step is selecting the correct chart type. The type of chart you choose fundamentally affects how your audience interprets the data. Here’s a quick rundown of the most common types and their best uses:

• Line Charts: Perfect for showing trends or changes over a period of time. Use a line chart to track stock prices, monthly website traffic, or regional temperature changes throughout the year.
• Bar/Column Charts: Ideal for comparing values across different categories. Use a column chart to compare Q1 sales figures for different products, or a bar chart to see social media follower counts by platform.
• Pie Charts: Use these to show the proportions of a whole. A pie chart is great for visualizing market share distribution or the breakdown of a marketing budget. Use them sparingly as they become difficult to read with more than a few slices.
• Scatter Plots: Best for showing the relationship or correlation between two different numerical variables. For example, you could plot advertising spend against sales revenue to see if they are related.

Once you’ve created your chart (by selecting your data and going to Insert > Charts), you’re ready to start formatting.

Understanding Excel’s Chart Formatting Tools

When you click on a chart in Excel, two new contextual tabs will appear in the main ribbon at the top of the window: Chart Design and Format. This is your command center for styling your graph.

Graphed

Still Building Reports Manually?

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

Watch the Demo

The Chart Design Tab

This tab focuses on the overall structure and look of your chart. Here you’ll find:

• Add Chart Element: This is arguably the most important button. It's a dropdown menu that lets you add, remove, or reposition key components like axes, titles, data labels, the legend, gridlines, and more.
• Quick Layout: Offers a selection of pre-designed layouts that rearrange standard elements like the title, legend, and data labels for you. It’s a good starting point if you’re unsure how to arrange things.
• Change Colors: Provides themed color palettes to quickly change the look and feel of your chart’s data series.
• Chart Styles: A gallery of pre-set styles that apply color, shading, and line-weight effects to your chart for a quick makeover.

The Format Pane: For Ultimate Control

For more detailed and granular control, you'll want to use the Format Pane. Double-clicking on any element of your chart (like a bar, a line, the chart title, or an axis) will open a sidebar on the right side of your screen. This pane gives you deep control over the specific element you selected.

For example, if you double-click a bar in your column chart, the Format Data Point pane will open, letting you change its fill color, add a border, or apply a shadow effect.

How to Format Key Chart Elements Step-by-Step

Let's break down how to format the most critical components of your graph to ensure it's easy to read and understand.

1. Writing and Formatting Titles

Your chart title should tell the viewer exactly what they are looking at. A good title is descriptive and concise.

• Add or Edit a Title: If your chart doesn’t have a title, select the chart, go to Chart Design > Add Chart Element > Chart Title, and choose a position (like "Above Chart"). To edit an existing title, simply click on the text box and start typing.
• Tip for Effective Titles: Instead of "Quarterly Sales," use a more descriptive title like "Total Sales Growth: Q1 vs. Q2 2024."
• Formatting Text: Click on the title textbox. Use the Home tab on the Excel ribbon to change the font, size, color, and add bold or italics. Double-clicking the title will also open the Format Pane for more options like adding a fill color or border to the textbox itself (though it is usually best to keep it simple).

Graphed

Still Building Reports Manually?

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

Watch the Demo

2. Adjusting the Axes for Clarity

The horizontal (X-axis) and vertical (Y-axis) axes provide the scale and context for your data. Poorly formatted axes can be confusing or even misleading.

• Change the Scale: Double-click on the vertical (value) axis to open the Format Axis pane. Under "Axis Options," you can set the "Bounds" (minimum and maximum values). For example, if your values range from 850 to 1,000, you could set the minimum bound to 800 to make the differences more visible. (Be careful: this can also exaggerate small changes, so use this technique ethically).
• Adjust Number Formatting: Within the same Format Axis pane, find the "Number" section at the bottom. Here, you can change the format to Currency, Percentage, or reduce the number of decimal places to make the labels cleaner.
• Format Axis Lines and Labels: Click on an axis to select it. You can change the font size and color of the axis labels from the Home ribbon. In the Format Axis pane, under the Fill & Line icon, you can change the color and thickness of the axis line itself.

3. Styling the Data Series (the Lines, Bars, or Slices)

The data series is the visual representation of your numbers - the colored bars, lines, or pie slices. This is where your story really comes to life.

• Change Colors: Simply right-click on a data series and select "Format Data Series." In the Format Pane, go to the "Fill & Line" tab. For bar charts, you can change the fill color (try using your brand’s colors for consistency). For line charts, you can adjust the line color, thickness, and style (solid, dashed, dotted).
• Modify Bar Spacing: In a bar or column chart, double-click on a bar, go to "Series Options" in the Format Pane, and adjust the "Gap Width." Decreasing the gap width makes the bars thicker and more prominent.
• Add Data Labels: Select your chart and go to Chart Design > Add Chart Element > Data Labels. You can place the actual numerical values directly onto your chart (e.g., above each bar or next to each data point on a line). This helps your audience grasp exact figures without looking back and forth from the axis.

4. Taming Gridlines and the Plot Area

Default gridlines in Excel can be visually distracting and add "chart junk," or unnecessary visual clutter that detracts from the data.

• Soften or Remove Gridlines: Click on a gridline to select all of them. In the Format Pane, you can change the color to a light gray to make them less intrusive. Alternatively, you can remove them entirely by going to Chart Design > Add Chart Element > Gridlines and unchecking them, or simply selecting them and pressing the Delete key. A cleaner background allows the data to stand out more.
• Format the Plot Area: You can select the inner "plot area" (the space where the data is actually graphed) and give it a subtle background color or border through the Format Pane, but in most cases, a clean, white background is most effective.

5. Fine-Tuning the Legend

The legend tells the viewer what each color or symbol in your chart represents. It's crucial for charts with multiple data series.

• Move the Legend: Select the chart, then go to Chart Design > Add Chart Element > Legend and choose the best placement (Top, Left, Bottom, or Right). Often, placing it at the top or right keeps it out of the way of the data.
• Remove an Unnecessary Legend: If your chart only shows one data series, the legend is redundant. You've already described the data in your chart title! Click the legend and press Delete to remove it and give your data more room to breathe.

Bonus Tip: Save Your Style as a Chart Template

If you have to create the same type of chart repeatedly, you can save your formatting work as a template. Once your chart is formatted exactly how you want it:

1. Right-click on the chart.
2. Select "Save as Template..."
3. Give your template a name and click Save.

The next time you need to create that chart, go to Insert > Charts, click the "All Charts" tab, go to the "Templates" folder, and select your custom-saved template. All your formatting will be applied automatically.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Final Thoughts

Formatting graphs in Excel goes far beyond just picking colors. It's about designing a clear, uncluttered visual that guides your audience to the right conclusion. By taking control of titles, axes, data series, and other elements, you can elevate a simple spreadsheet chart into a powerful communication tool.

While mastering all these clicks and adjustments in Excel dashboards is incredibly useful, we know that the manual process can be time-consuming, especially when you need answers quickly. For this reason, we created Graphed. Instead of wrestling with formatting panes, you can just connect your data sources (like Google Analytics, Shopify, or even spreadsheets) and build dashboards in seconds by asking in plain English. For example, you can simply ask, "create a bar chart showing revenue by campaign for last month," and Graphed builds a live, professional-looking chart for you instantly, skipping all the manual busywork.