In this case, it’s pretty straightforward: Lucy has a column header for the month and a column header for the number of email subscribers. You should also ensure that you have descriptive column headers for your data. Taking even just a little bit of time to check over your data could prevent you from having to go back and make changes after you see something off in your chart. So, whatever errors you have there will also appear in your chart. Remember, the charts you build within Excel are going to pull directly from your data set. Get your data readyīefore she dives right in with creating her chart, Lucy should take some time to scroll through her data and fix any errors that she spots-whether it’s a digit that looks off, a month spelled incorrectly, or something else. How to build an Excel chart: A step-by-step Excel chart tutorial 1.

But, she really wants to make an impact-so, she’s going to use an Excel chart to display the subscriber growth she’s worked so hard for. Sure, the numbers themselves show impressive growth, and she could simply spit out those digits during her presentation. She really wants to knock the presentation out of the park-because, when you boil it down, this information proves that she’s doing her job well.Ĭurrently, she has the total number of email subscribers for each month of 2017 in a simple Excel spreadsheet that looks like this: She has to deliver a presentation to her organization’s leadership team, where she’ll highlight the growth of email subscribers over the past 12 months. She works on the marketing team at her company and is primarily responsible for all of the email marketing campaigns. Now that you know more about pivot tables in Excel 2013, learn more.Growth in email subscribers: An Excel charts case study As such, we recommend that you try one of our other Excel tutorials to become familiar with the Excel version that you will be using. Display a hidden value in a pivot tableĮach version of Excel can 'look and feel' completely different from another.Display the fields in the values section as a single column.Display the fields in the values section as multiple columns.Change how empty cells are displayed in a pivot table.Change how errors are displayed in a pivot table.

Show the Bottom 10 results in a pivot table.Show the Top 10 results in a pivot table.Remove grand totals for rows in a pivot table.Remove grand totals for columns in a pivot table.Change the data source for a pivot table.In this Excel 2013 tutorial, we covered the following: Each version of Excel can 'look and feel' completely different from another. Tutorial SummaryĮxcel 2013 is a version of Excel developed by Microsoft that runs on the Windows platform. MS Excel 2013: Pivot Tables (Tutorial Complete)Ĭongratulations, you have completed the Excel 2013 tutorial that explains Pivot Tables in Excel 2013.

Excel pivot charts tutorial