1 00:00:00,05 --> 00:00:02,00 - [Instructor] Let's create some charts 2 00:00:02,00 --> 00:00:03,04 to go along with this data 3 00:00:03,04 --> 00:00:07,01 so we can visually see how that data is represented. 4 00:00:07,01 --> 00:00:09,00 To get started, click and drag 5 00:00:09,00 --> 00:00:12,06 and highlight any data that you want represented by a chart. 6 00:00:12,06 --> 00:00:14,04 Be sure to leave off any totals, 7 00:00:14,04 --> 00:00:17,00 as that can wreak some havoc in your data. 8 00:00:17,00 --> 00:00:20,00 Once it's selected, you have a few options. 9 00:00:20,00 --> 00:00:22,02 You can change to the Insert ribbon tab, 10 00:00:22,02 --> 00:00:23,04 and, right in the middle, 11 00:00:23,04 --> 00:00:24,05 you can hover your mouse 12 00:00:24,05 --> 00:00:26,02 over a particular type of chart 13 00:00:26,02 --> 00:00:29,00 if you know exactly what you're looking for. 14 00:00:29,00 --> 00:00:31,02 However, with this data selected, 15 00:00:31,02 --> 00:00:34,03 Excel realizes that it can become a chart. 16 00:00:34,03 --> 00:00:36,06 There's a button called Quick Analysis 17 00:00:36,06 --> 00:00:40,04 that pops up on the bottom right-hand side of your data. 18 00:00:40,04 --> 00:00:42,09 If I click this button, here's where I can see 19 00:00:42,09 --> 00:00:46,07 where I can enter tables, totals, and charts. 20 00:00:46,07 --> 00:00:48,06 I'll click on Charts. 21 00:00:48,06 --> 00:00:50,08 And if I hover my mouse over the data, 22 00:00:50,08 --> 00:00:52,08 I can see what it's going to look like. 23 00:00:52,08 --> 00:00:54,07 I'll click on one, 24 00:00:54,07 --> 00:00:57,09 and instantly I get a clustered column chart. 25 00:00:57,09 --> 00:01:00,01 Now, this chart works just like an image, 26 00:01:00,01 --> 00:01:05,00 meaning, I can drag it around anywhere on my spreadsheet. 27 00:01:05,00 --> 00:01:06,09 I can make it larger or smaller 28 00:01:06,09 --> 00:01:09,00 by dragging and clicking on the corners. 29 00:01:09,00 --> 00:01:11,01 I can make it bigger. 30 00:01:11,01 --> 00:01:12,09 So right away I can move it around. 31 00:01:12,09 --> 00:01:14,08 But there's a lot of other interactions 32 00:01:14,08 --> 00:01:17,01 that I can do with this chart. 33 00:01:17,01 --> 00:01:18,04 To the right of the chart, 34 00:01:18,04 --> 00:01:19,07 I can click the plus sign 35 00:01:19,07 --> 00:01:21,04 to add or remove elements 36 00:01:21,04 --> 00:01:25,02 like legends and trendlines and axis titles. 37 00:01:25,02 --> 00:01:26,03 I can click the paintbrush 38 00:01:26,03 --> 00:01:29,03 to set a style and color scheme for the chart. 39 00:01:29,03 --> 00:01:32,09 And I can also use filters to edit data points. 40 00:01:32,09 --> 00:01:35,07 At any time when you select a chart, 41 00:01:35,07 --> 00:01:37,09 two new ribbon tabs appear. 42 00:01:37,09 --> 00:01:40,04 The first one is Chart Design, 43 00:01:40,04 --> 00:01:42,04 and you can click on Chart Styles in the middle 44 00:01:42,04 --> 00:01:45,04 to see different ways that your data is represented. 45 00:01:45,04 --> 00:01:47,04 In fact, you can hover your mouse over each one 46 00:01:47,04 --> 00:01:48,05 to get a preview 47 00:01:48,05 --> 00:01:52,00 of how it's going to change the way the chart looks. 48 00:01:52,00 --> 00:01:54,01 This is just changing it visually. 49 00:01:54,01 --> 00:01:56,09 It's not changing the data in any way, shape, or form. 50 00:01:56,09 --> 00:01:59,00 It's just making it look different. 51 00:01:59,00 --> 00:02:02,03 You can also change the colors of your chart. 52 00:02:02,03 --> 00:02:03,06 On the right-hand side, 53 00:02:03,06 --> 00:02:05,09 you can switch the row and column data, 54 00:02:05,09 --> 00:02:08,02 and you can also change the data range 55 00:02:08,02 --> 00:02:10,01 that's selected for the chart. 56 00:02:10,01 --> 00:02:12,09 Finally, I can click Change Chart Type. 57 00:02:12,09 --> 00:02:15,05 I don't like this particular clustered column. 58 00:02:15,05 --> 00:02:19,00 For example, I have a line chart, pie, bar. 59 00:02:19,00 --> 00:02:21,06 There's so many different types of chart designs. 60 00:02:21,06 --> 00:02:23,05 Excel is so powerful, 61 00:02:23,05 --> 00:02:24,08 and you might want to go through 62 00:02:24,08 --> 00:02:27,09 and see which one will work best to represent your data. 63 00:02:27,09 --> 00:02:31,00 In fact, even with this clustered column selected, 64 00:02:31,00 --> 00:02:34,00 I can still click across and change the way it's displayed, 65 00:02:34,00 --> 00:02:42,05 for example, a 3D stacked column. 66 00:02:42,05 --> 00:02:45,07 Let's go to a different chart. 67 00:02:45,07 --> 00:02:48,00 This one has percentages on it. 68 00:02:48,00 --> 00:02:50,04 I think this would be great as a pie chart. 69 00:02:50,04 --> 00:02:53,09 I'll select the data. 70 00:02:53,09 --> 00:02:56,05 I'll click Quick Analysis again. 71 00:02:56,05 --> 00:02:58,08 Select Charts. 72 00:02:58,08 --> 00:03:03,00 And, this time, I'll select a pie chart. 73 00:03:03,00 --> 00:03:06,07 And, again, I can move this around anywhere. 74 00:03:06,07 --> 00:03:08,02 I can resize it 75 00:03:08,02 --> 00:03:11,07 and change the way it looks in the Chart Design tab. 76 00:03:11,07 --> 00:03:14,00 If I hover my mouse over the chart styles, 77 00:03:14,00 --> 00:03:16,08 it gives me a lot of different choices. 78 00:03:16,08 --> 00:03:18,08 Many of these are PowerPoint ready, 79 00:03:18,08 --> 00:03:25,07 ready to be brought right into a presentation. 80 00:03:25,07 --> 00:03:27,01 This looks great. 81 00:03:27,01 --> 00:03:29,04 We'll do one more. 82 00:03:29,04 --> 00:03:34,01 I'll select the data. 83 00:03:34,01 --> 00:03:35,07 And put it in a chart. 84 00:03:35,07 --> 00:03:38,07 But, this time, I'm going to choose More Charts 85 00:03:38,07 --> 00:03:42,02 because I think that this would be great as a line chart. 86 00:03:42,02 --> 00:03:44,07 It's going to show me some recommended charts, 87 00:03:44,07 --> 00:03:46,02 but I can change that. 88 00:03:46,02 --> 00:03:48,02 I'm going to click All Charts, 89 00:03:48,02 --> 00:03:51,04 and, this time, I'll choose line. 90 00:03:51,04 --> 00:03:55,03 I'll click OK. 91 00:03:55,03 --> 00:03:57,00 And here's my chart. 92 00:03:57,00 --> 00:03:58,08 Now, again, this is your chart. 93 00:03:58,08 --> 00:04:00,04 You can do anything you want. 94 00:04:00,04 --> 00:04:02,07 For example, I can click inside the chart title 95 00:04:02,07 --> 00:04:05,08 and change the text. 96 00:04:05,08 --> 00:04:12,05 I'll put in my heading. 97 00:04:12,05 --> 00:04:14,05 I can change the legend. 98 00:04:14,05 --> 00:04:16,05 And if the data doesn't look right to you, 99 00:04:16,05 --> 00:04:18,06 you can always change it. 100 00:04:18,06 --> 00:04:20,02 Some data looks better 101 00:04:20,02 --> 00:04:22,06 and is more readable with certain chart types, 102 00:04:22,06 --> 00:04:25,06 so you can always go through and change the chart type 103 00:04:25,06 --> 00:04:27,00 to find the proper chart type 104 00:04:27,00 --> 00:04:29,04 that's going to correctly tell the story of your data 105 00:04:29,04 --> 00:04:31,00 that you're looking to tell.