In order to use charts effectively, you'll need to understand how different charts are used.Ĭlick the arrows in the slideshow below to learn more about the types of charts in Excel.Įxcel has a variety of chart types, each with its own advantages. Understanding chartsĮxcel has several different types of charts, allowing you to choose the one that best fits your data. 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.Optional: Download our practice workbook. 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 kommentar(er)
