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.

How to create pie chart in excel 2011