There’s no magic behind text boxes insert the as you normally would just like when you’re using Word or PowerPoint. In the Label Contains section, place a check mark in either the Series Name or Category Name box. Then, right-click on that same data point again and select Format Data Label. In Microsoft Excel, right-click on the data point on the far right side of the line and select Add Data Label. Format the data labels so that the label contains the category name.To insert labels next to the lines, you can: The goal is to get the labels as close as possible to the actual line so that your viewers aren’t zig-zagging their eyes back and forth between the lines and the legend. Then, insert those labels beside their corresponding lines. These data labels and separate legend score a big fat zero on the Data Are Labeled Directly section of the Data Visualization Checklist. This graph is challenging to read in color (which turquoise category goes with which line?) and would be impossible to read when printed or photocopied in grayscale. Instead, let's make a Line with Markers chart.Ĭlick Line, click Line with Marker, point to an option and you get a preview of the chart.Ĭlick OK, and we have created our line chart.The topic caught my attention but the separate legend about the line graph made me cringe. We could make a Pie chart, but it would only show the first data series, the Average Precipitation for New York, and not the second data series, the Average Precipitation for Seattle. These are all of the different types of charts you can create.Īs I mentioned earlier, a pie chart is not a recommended option for the data we selected, because it can only display one data series. In the Charts group, we have a lot of options.Ĭlick Recommended Charts to see the charts that will work best with the data you have selected click All Charts for even more options. To create charts that aren't Quick Analysis options, select the cells you want to chart, click the INSERT tab. We are creating some of the more common chart types, but there are many more options. Now, I am creating a bar chart using the same data we used to create the pie chart.Ĭharting the same data different ways can provide you with a different perspective that may help you discover different insights in the data. If you try to graph too much data in a pie chart it looks like this, not very useful. I scroll down a little, click the bottom right-hand corner of the chart, and drag it up and to the left to make it smaller.ĭifferent data displays better in different types of charts. I click the chart hold down the left mouse button, and drag to move it. I am going to move and resize the chart, so it displays without having to scroll, which will also make it easier to customize (something we'll look at in the next video.) In this example, those are the Sales figures in cells B2 through B5. You can chart only one data series with a pie chart. I'll show you how to create a chart that isn't a Quick Analysis option, shortly.Ĭlick the Pie option, and your chart is created. To create a pie chart, select the cells you want to chart.Įxcel displays recommended options based on the data in the cells you select, so the options won't always be the same. In this video, we are going to create pie, bar, and line charts.Įach type of chart highlights data differently.Īnd some charts can't be used with some types of data. We created a clustered column chart in the previous video.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |