6 Tips for Making Microsoft Excel Charts That Stand Out

Join 425,000 subscribers and get a daily digest of news, geek trivia, and our feature articles.
By submitting your email, you agree to the Terms of Use and Privacy Policy.
With her B.S. in Information Technology, Sandy worked for many years in the IT industry as a Project Manager, Department Manager, and PMO Lead. She learned how technology can enrich both professional and personal lives by using the right tools. And, she has shared those suggestions and how-tos on many websites over time. With thousands of articles under her belt, Sandy strives to help others use technology to their advantage. Read more…
Excel Charts and Graphs
Excel makes creating a chart or graph easy, but there are certain things you can do to make your chart more effective. This list of tips can make your graph a successful visual display of your data.
Many of our guides to creating charts, like creating a treemap, offer essential customizing advice that often applies to that specific kind of chart. However, the tips you see here can make any graph stand out, regardless of the chart type.

Select the Right Chart for the Data
Include a Descriptive Title
Use a Legend Only When Beneficial
Choose Your Colors Wisely
Brand Your Chart
  Add Your Logo
  Brand the Title or Subtitle
Keep It Clean and Easy to Read

The first step in creating a chart or graph is selecting the one that best fits your data. You can gain a lot of insight on this by looking at Excel’s suggestions.
Select the data you want to plot on a chart. Then, head to the Insert tab and Charts section of the ribbon. Click “Recommended Charts” to see which types of graphs Excel believes fit your data.
Recommended Charts in Excel
You can also take a look at our helpful guide for finding the right Excel chart for the type of data in your sheet.
While a chart’s job is to display your data so that it can be clearly understood, you also want to include a title. This is especially important if you plan to share the chart as an image on its own in an email or social media post.
RELATED: How to Save a Chart as an Image in Microsoft Excel
For instance, maybe you have a chart of first-quarter sales for your east coast division. Using a title that simply says “Sales” isn’t nearly as descriptive as “East Coast Sales — Quarter One.”
Excel adds a default title to each chart you create, but you can change it easily. Select the chart and then click the default Chart Title text box. Then just type in your own title.
Chart title
If you have a chart where a legend helps the viewer understand what they’re seeing, then you should definitely use one. But if your graph is clear on its own and there’s no need for a legend, remove it so the view is less cluttered. Let’s look at an example of both.
In the column chart on the left, you see colored columns and dollar amounts. But what does each column represent? By adding a legend, everyone has a clear picture of the data.
Column chart with and without a legend
In the pie chart on the left, you can see each slice represents the color and there are data labels to confirm that. For this type of situation, a legend is an unnecessary distraction.
Pie chart with and without a legend
You can also position the legend in a different spot than the default location. Select the chart, go to the Chart Design tab and click the Add Chart Element drop-down arrow. Move your cursor to Legend and pick a location for the legend in the pop-out menu.
Select a position for the legend
Most any type of chart in Excel uses some color. Whether it’s a pie chart with different colored slices or a scatter plot with a handful of colored dots, you’ll have color to distinguish the data. Luckily, Excel applies a color palette that you can customize.
RELATED: How to Make a Pie Chart in Microsoft Excel
In the bar chart below, you can certainly see the colors pop off the chart. Unfortunately, it looks more like a box of highlighters than a depiction of sales.
Bright colored chart
By using a standard Excel palette, our bar chart not only is simple to read but also doesn’t give you a headache.
Color palette chart
You can customize the colors any way you like; using your organization’s colors is a good option. The key is to be sure you choose colors that are pleasing and also contrast one another.
RELATED: What Is a Hex Code for Colors?
One thing that’s often overlooked when making a graph in Excel is also the one thing that can make your chart distinctive. That’s branding. You have a few different ways to brand your chart so that it’s clearly yours but doesn’t distract.
RELATED: How to Make a Graph in Microsoft Excel
If you can add your organization’s logo to a corner of the chart, this is the simplest way to brand it. That small logo lets everyone know who the data belongs to.
Chart with company logo
Earlier we mentioned including a descriptive title to your chart. If using a logo creates too much clutter, consider simply adding your company name to the chart title or even as a subtitle.
Chart with company as the subtitle
One final tip for creating a chart that tells the story of the data well is to keep it clean, simple, and easy to read. Don’t overcomplicate your chart with unnecessary elements.
Just like the earlier tip for only using a legend when it’s useful, the same can be said of elements like axis titles, a trendline, or data labels. For example, you may feel that data labels help by providing additional detail. But as you can below, those data labels, no matter where they’re placed, clutter the chart and make it difficult to read clearly.
Excel chart with data labels
Instead, try arranging the data differently or even using another chart element. In the chart below, we added a data table rather than data labels. This allows us to display those additional details we want, but still keeps the chart neat and clean.
Excel chart with a data table
Hopefully these tips will help you create and customize a chart, such as a waterfall chart, that has a professional appearance and clearly depicts your data.
RELATED: How to Create and Customize a Waterfall Chart in Microsoft Excel
JOIN GEEK TALK ON FACEBOOK
Facebook
Instagram
Twitter
LinkedIn
RSS Feed
The Best Free Tech Newsletter Anywhere
By submitting your email, you agree to the Terms of Use and Privacy Policy.

source

Digital Strategist Chris Hood

Leave a Reply

Your email address will not be published. Required fields are marked *

© 2022 SHAQ HAX - Proudly powered by theme Octo