Also, if your charts are printed in black and white, you need to make sure the difference in slice colors is noticeable. While you can use a lot of colors, keep it to a minimum (even different shades of the same color is fine).
#How to do pie charts in excel 2013 pro#
Pro Tip: It’s best to keep your Pie Charts simple. Almost every element of it can be modified/formatted. There are a lot of customizations you can do with a Pie chart in Excel. You can also easily format these data labels to look better on the chart (covered later in this tutorial). This will instantly add the values to each slice. To add the data labels on each slice, right-click on any of the slices and click on ‘Add Data Labels’. While you can figure out the approximate value of each slice in the chart by looking at its size, it’s always better to add the actual values to each slice of the chart. The above steps would instantly add a Pie chart on your worksheet (as shown below).
#How to do pie charts in excel 2013 how to#
Let me first cover how to create a Pie chart in Excel (assuming that’s what you’re here for).īut I do recommend that you go on and read all the things covered later in this article as well (most importantly the Pros and Cons section). You can have any value as the total value of the chart (which becomes 100%) and all the slices will represent a percentage of the total value. Note that I have chosen 100% as the total value. The entire pie chart represents the total value (which is 100% in this case) and each slice represents a part of that value (which are 45%, 25%, 20%, and 10%). Or to put it simply, it’s something as shown below. The length of the pie arc is proportional to the quantity it represents. Each part (slice) represents a percentage of the whole. it has nothing to do with food (although you can definitely slice it up into pieces).Ī pie chart (or a circle chart) is a circular chart, which is divided into slices. I will not spend a lot of time on this, assuming you already know what it is.Īnd no.
Without the data labels it is difficult to understand what each slice indicates.ġ) Move the mouse over the chart for which you want to add data labels.Ģ) Right click the chart. The slices are the figures or the units sold (10, 20, 30 etc.). It shows the slices, the title and the legend (apr, may etc.). You will have to add or remove Data labels on your own. When you insert a Pie chart on your worksheet, it will show different slices, a title and a legend, without the data labels.
The data labels make a chart easier to understand. You can use this option to analyze the data.Īdd or Remove Data Labels to a Pie Chart (Excel 2007)ĭata labels are data (or figures) associated with each slice. Double click a particular slice, hold and drag it out to separate it from the other slices. You can separate a Pie chart slice (or all the slices). There are other features associated with the Pie chart, which you can use to enhance user experience. Next, hold the Ctrl key, click the 3rd column (ruler) and drag the mouse till the last row. Click the mouse on the first column, first row and drag the mouse down until the last row. Similarly, you can create another chart by choosing the next column’s data (that is ruler), along with the first column data.
0 kommentar(er)
