• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

Recommended Charts in Excel

August 22, 2021 by Andrew Childress
Recommended charts in Excel

When you’re working in spreadsheets, it’s often useful to add charts to add extra visual interest. Here's how to add recommended charts in Microsoft Excel.

When you’re working in spreadsheets, it’s often useful to add charts to add extra visual interest. One great way to do this is to use charts in Excel. Fortunately, you don’t have to be an Excel chart expert to bring these to your own files. Let’s learn how to add recommended charts in Microsoft Excel.

How to Add Recommended Charts in Microsoft Excel

Microsoft Excel offers a variety of ways to add unique charts to any spreadsheet. These include line charts, bar charts, pie charts, and many more. When you have data formatted, you can choose from any of them. But sometimes, it’s difficult to know which chart style to choose.

Luckily, Microsoft Excel has you covered. The Recommended Charts feature is a smart option that analyzes your data and instantly determines what type of chart fits it best.

Imagine, for example, that you have a list of years in a column of your spreadsheet, with annual revenue figures in the adjacent column. A line chart would be a great way to illustrate the annual growth reflected in your data. But you don’t have to build a line chart layout from scratch.

Begin by inputting your data in Excel as you see below. In column A, you have the years listed. Column B shows the annual revenue. Then, click and drag to select your dataset, which here is the range A1:B5. Then, go to the Insert tab on Excel’s ribbon.

Recommended charts in Excel

You’ll see an array of options, and you’ll want to click on the Recommended Charts dropdown. Excel will instantly analyze your data, and suggest the most logical and likely chart styles to use. In this case, you’ll see thumbnails illustrating a line chart, a clustered column chart, and more.

Add recommended charts in Excel

Click on any of them, and Excel will insert the selected chart style right onto your sheet.

Insert recommended charts in Excel

As you can see, this is a great way to add charts to your spreadsheets, with no tedious design work involved.

Category: Excel FunctionsTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post:Add images in ExcelAdd Pictures in Excel
Next Post:Add SmartArt in ExcelCustomize Excel smartart

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

    • Facebook
  • Twitter
  • Instagram
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top