Everand Logo

Welcome to Everand!

  • Discover millions of ebooks, audiobooks, and so much more with a free trial

    From $11.99/month after trial. Cancel anytime.

    Excel 2019 Charts: Easy Excel Essentials 2019, #2
    Excel 2019 Charts: Easy Excel Essentials 2019, #2
    Excel 2019 Charts: Easy Excel Essentials 2019, #2
    Ebook64 pages31 minutes

    Excel 2019 Charts: Easy Excel Essentials 2019, #2

    By M.L. Humphrey

    ()

    Read preview

    About this ebook

    Charts are a fantastic tool for visualizing data. They can let you easily see patterns that a table of numbers doesn't show.

     

    This book covers the most common types of charts, namely bar, column, pie, doughnut, and line charts as well as scatter plots and histograms.

     

    * * *

    The Easy Excel Essentials 2019 series of titles are for intermediate-level users who want to focus on one specific topic such as PivotTables, Charts, Conditional Formatting, or the IF Functions.

     

    The content of each title is extracted from either Excel 2019 Intermediate or Excel 2019 Formulas & Functions which cover intermediate-level Excel topics in more detail. These books are written using Excel 2019 and assuming that a user is working in that program. If you are using an older version of Excel, the Easy Excel Essentials series may be a better choice since it was written using Excel 2013 and for a more general audience of Excel users.

    LanguageEnglish
    PublisherM.L. Humphrey
    Release dateFeb 15, 2021
    ISBN9781393898382
    Excel 2019 Charts: Easy Excel Essentials 2019, #2
    Author

    M.L. Humphrey

    Hi there Sci Fi fans, my name is Maurice Humphrey. I am a Vermont native, husband, father, grandfather, well over 60, Navy veteran, retired IBM engineer, retired printer repairman, Graduated: Goddard Jr. College, VT Technical College, and Trinity College. Over the years I've written technical articles, taught technical classes, and presented at technical conventions. I've been reading science fiction for over 50 years now. First books were "Journey to the Centre of the Earth" by Jules Verne and "The Stars Are Ours" by Andre Norton. I've read and collected many great stories, and a considerable amount of junk ones as well. I'd say by now that I probably have a good idea of what I consider a good story.

    Read more from M.L. Humphrey

    Related to Excel 2019 Charts

    Titles in the series (4)

    View More
    View More

    Related ebooks

    Enterprise Applications For You

    View More
    View More

    Related podcast episodes

    Related categories

    Reviews for Excel 2019 Charts

    0 ratings

    0 ratings0 reviews

    What did you think?

    Tap to rate

    Review must be at least 10 words

      Book preview

      Excel 2019 Charts - M.L. Humphrey

      Excel 2019 Charts

      Also by M.L. Humphrey

      Listing of all books by M.L. Humphrey

      Easy Excel Essentials 2019

      Excel 2019 PivotTables

      Excel 2019 Charts

      Excel 2019 Conditional Formatting

      Excel 2019 IF Functions

      Excel Essentials 2019

      Excel 2019 Beginner

      Excel 2019 Intermediate

      Excel 2019 Formulas & Functions

      Access Essentials

      Access for Beginners

      Intermediate Access

      Excel 2019 Charts

      Easy Excel Essentials 2019 - Book 2

      M.L. Humphrey

      Contents

      Introduction

      Charts – Discussion of Types

      Charts - Editing

      Conclusion

      Appendix A: Basic Terminology

      About the Author

      Copyright

      Introduction

      The Easy Excel Essentials 2019 series of titles are for intermediate-level users who want to focus on one specific topic such as PivotTables, Charts, Conditional Formatting, or the IF Functions.

      The content of each title is extracted from either Excel 2019 Intermediate or Excel 2019 Formulas & Functions which cover intermediate-level Excel topics in more detail.

      These books are written using Excel 2019 and assuming that a user is working in that program. If you are using an older version of Excel, the Easy Excel Essentials series may be a better choice since it was written using Excel 2013 and for a more general audience of Excel users.

      With that introduction, let’s dive in on how to use Charts.

      Charts – Discussion of Types

      Charts are a great way to visualize your data. They take a big pile of numbers and turn them into a pretty picture. And, like they say, a picture is worth a thousand words.

      I’m pretty good at recognizing patterns if you let me skim an entire data set, but a chart can show what I feel is true (such as that a large percent of sales are coming from one source) with just a few clicks and a big block of color.

      Data Format

      First things first, your data needs to be arranged properly to create a chart.

      Specifically, for most of the charts we’re going to discuss, you need one set of labels across the top and one set down the side with values listed in the cells where those two intersect. Do not include subtotals if you can avoid it (you’ll have to select around them if you do) and same with grand totals (you’ll have to leave them out when you choose your cells). Also, don’t include anything in the top left corner of the table where the row labels and column labels intersect.

      Here are two examples which would work equally well for this data set:

      Data table layout one

      This is fictitious sales data for each month for various sales platforms. In the first example, the sales channels are listed down the side and the months

      Enjoying the preview?
      Page 1 of 1