![create pie chart in excel 2013 create pie chart in excel 2013](https://i.ytimg.com/vi/59MjrXKh5bU/maxresdefault.jpg)
Click Add Data Label, then click Add Data Callout. To add a data label in a shape, select the data point of interest, then right-click it to pull up the context menu. It should look like this: In Excel 20, click the Recommended Charts item instead of Other Charts: Youll then see a dialogue box appear. Putting a data label into a shape can add another type of visual emphasis. Click OK and Excel will insert your chart. Select the first Line chart, the one highlighted in the image above.
Create pie chart in excel 2013 how to#
In the next part, you'll see how to add the viewing figures to the pie chart segments. From the dialogue box, the left hand side shows all the chart templates. The chart will then look like this (your labels may well be at the bottom, though, depending on which version of Excel you have):īut it looks pretty good for just a few mouse clicks! We can still do a bit more to it, though. Threats include any threat of suicide, violence, or harm to another. If you haven't got this style, select a similar one, such as style 4 in Excel 2013 and Excel 2016. Harassment is any behavior intended to disturb or upset a person or group of people. We've gone for the second one, Style two. To get different colours, make sure that your chart is selected and locate the Chart Style panel:Ĭlick the down arrow to the right of the Chart Style panel to reveal the available styles :
![create pie chart in excel 2013 create pie chart in excel 2013](https://i.ytimg.com/vi/e_i1PtFSH0g/maxresdefault.jpg)
![create pie chart in excel 2013 create pie chart in excel 2013](https://i.ytimg.com/vi/UO91EQ8Ycug/maxresdefault.jpg)
Create pie chart in excel 2013 series#
The series pair has a Positive Correlation if they increase similarly, and a Negative Correlation if they both decrease in like manner. See Scatter Charts with Lines to understand why this happens and how to fix it. Sometimes scatter charts with lines can be confusing if the line zig-zags and crosses itself. See Microsoft Excel: The Scatter Chart for more information. In general, markers work well when the number of data points is small, and smooth lines are often used with a large number of data points. Scatter charts come with or without markers, and data points can be connected with smooth or straight lines. The scatter chart is called the XY Chart because its data points are the intersection of two values on the X and Y-axis. The scatter chart observes the relationship between two variables. This tip is about how to create a pie chart such as in popular glossy magazines.