When you track data over time and write down when you capture that data, you can summarize it using a line chart.
- [Instructor] When you run a business, it's a good idea to keep track of how it performs over time. You can track total sales, number of new customers, and so on. When you do track data over time, and write down when you capture that data, you can summarize it using a line chart. I'll demonstrate how to create line charts in this movie. My sample file is the LineChart Workbook. And you can find it in the chapter seven folder of your exercise files collection. I have sales data or order data for four different product categories across three years.
Let's say that I want to indicate how battery orders have trended over time. To do that, I need to select the data, including the year numbers. So I will select cells A2 through D3. And then on the Insert tab of the ribbon, I'll go to the Charts group. Click the Line button's down arrow, or just click the button. And I'll select the basic 2-D line chart here.
And when I do, you can see that we have the values for 2016, which was 3933 when I hover over it, 5442 when I hover over for 2017, and 14363 for 2018. So that's a basic line chart. Let me delete the chart, which I still have selected. I just selected the chart and then pressed the Delete key. If I want to summarize all of my data series, so batteries, landscape, lighting, and so on, in a single chart, then I select all of the data.
So I'll select A2 through D6. And then, on the Insert tab of the ribbon, I will click the Line button again and this time, I'll add markers. So I will click the line with markers under the 2-D line area. And this chart is less successful than the previous one. I see that I have series for each of my years and my categories represent the horizontal axis. Even though the categories are in alphabetical order, they don't make any other sort of sense, especially not as far as time goes.
What I'd like to do is to put my years on the horizontal or x-axis and have the series refer to each of the categories. To do that, with the chart still selected, I'll go to the Chart Design contextual tab of the ribbon, which for me, is already selected. And then click the Switch Row/Column button. And doing so fixes the problem. I now have my four data series and I can see that they are arranged over time, left to right, from 2016 to 2017 and 2018.
Line charts give you a quick visual summary of how your data has trended over time. If you notice a sudden increase or decrease in your sales or other data, you should identify when the change occurred and investigate to see why it happened.
- Creating workbooks
- Manipulating cell data
- Sorting, filtering, and managing worksheets
- Using core functions and formulas
- Formatting worksheet elements
- Creating and managing conditional formats
- Working with charts
- Adding images and shapes
- Working with PivotTables
- Exporting workbooks
Skill Level Beginner
What you should know1m 11s
1. Getting Started with Excel
2. Managing Workbooks
3. Working with Worksheets, Cells, and Cell Data
4. Sorting, Filtering, and Managing Worksheets
5. Summarizing Data Using Formulas and Functions
6. Formatting Worksheet Elements
7. Working with Charts
8. Working with External Data and Objects
9. Exploring PivotTables
10. Reviewing and Sharing Spreadsheets
Further information1m 2s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.