Learn Excel Now

Conquer the Fear of Excel

  • Home
    • Our Team
  • Training
    • Custom Training
      • Custom Virtual Group Training
      • Custom Onsite Group Training
      • Consulting Services
    • Excel
    • MS Office
    • Outlook
    • PowerPoint
    • Word
    • OneDrive
    • Google
  • All-Access
  • eLearning
    • Excel Foundations
    • Micro Courses
      • Simply Excel
      • Simply Excel Pt. II
  • Resources
    • Contact
    • FAQ
    • New User Onboarding
  • Login

Excel Charts: Quick Tips for Getting Started

March 30, 2016 by Tyrone Pernsley

Creating Excel Charts Featured ImageExcel’s true power starts with storing and analyzing data but really begins to jump of the page with Charts. Excel charts allow users to graphically represent their data in a meaningful way. Users can easily create and customize charts. With the power of Charts, you can quickly summarize data, compare and track trends over time and see how your business is performing. You also have a tool to quickly report these numbers to colleagues and superiors.

Today, we are going to focus on creating an Excel Chart.

To create a chart, you would:

  • Select the data you want to appear on the chart
  • Go to the Insert ribbon and select the type of chart you want to use

Pro tip: there are also keyboard shortcuts to create charts:
Press F11 – a chart appears on a new workbook tab (worksheet)
Press Alt+F1 – a chart will appear on the same worksheet as the data source*

*When selecting charts from the Insert ribbon, they automatically appear on the same worksheet.

Creating Excel Charts GIF 1

Source Data for Your Chart

The quality of your chart will depend on the quality of the source data that goes into the chart. Here are a few pointers to help you create the best chart possible:

  • Select numerical cells – these will render better in the chart
  • Have a column label on the first row of each column describing the data
  • Have a row label in the first column of each row describing the data
  • It is usually best to not include totals, averages, percentages, etc. – your chart will calculate these

Creating Excel Charts Image 1

Creating Chart from a Pivot Table

Now, let’s say you wanted to take our Salary list chart and break it down even further. In this instance, we are looking at Total Salary by Department.

To create a chart from a Pivot Table, you would:

  • Create the Pivot Table from the sources data
  • Move “Department” to Axis (row labels)
  • Move “Salary” to Values
  • Select the chart you want to use

Creating Excel Charts GIF 2

And now, as you can see, we have a chart quickly showing the breakdown of salary by department.

We here at Learn Excel Now hope you enjoyed these simple tips for getting started with Excel Charts. This just begins to scratch the surface of all the things you can do with Excel Charts, but shows the necessary beginning steps. Stay tuned for more Excel tips from Learn Excel Now.

Like Learn Excel Now? Share this article and our other content with your social networks.

Kevin – Learn Excel Now

Easily Combining Excel Charts

December 2, 2015 by Tyrone Pernsley

Combine Charts image1Learn Excel Now brings you our tip of the week: easily combining Excel charts. [Read more…]

Creating 3-D Formulas in Excels for Multiple Worksheets

November 11, 2015 by Tyrone Pernsley

A 3-D formula in Excel can be used to calculate data using multiple worksheets in a workbook. Check out these tips to learn how to create and use 3-D formulas in Excel. [Read more…]

All Access Subscription
Our 1-year all-access subscription provides step-by-step guidance for mastering Microsoft Office applications, with workshops, exercises and quick reference eGuides. It's perfect for anyone that needs to brush up on certain skills or even folks who need to learn the programs - from a beginner’s level.
Excel Foundations
Take the fear out of Excel with this 20 module self-paced training course. You will cover the most essential topics to develop a solid foundation of Excel or a lifetime of mastery.

Learn Excel Now helps you conquer the fear of Excel. By providing self-paced and instructor-led training and free strategies and guides, we leave no Excel mystery unsolved.

  • Home
  • Training
  • All-Access
  • Excel Foundations
  • Resources

Connect with Us

  • Facebook
  • Linkedin

Contact

Learn Excel Now
questions@learnexcelnow.com
1-484-259-7664 or 1-800-964-6033
660 American Ave
Suite 203
King of Prussia, PA 19406

Microsoft® Office Excel® is a registered trademark of the Microsoft Corporation in the United States and other countries. All rights reserved.

Copyright © 2023 ­Learn Excel Now

Terms of Service

Privacy Policy

Copyright © 2023 · News Pro Theme on Genesis Framework · WordPress · Log in

WELCOME BACK!

Enter your username and password below to log in

Forget Your Username or Password?

Reset Password

Lost your password? Please enter your username or email address. You will receive a link to create a new password via email.

Log In