In my case I had to move it by 90 degrees. On the right under “angle of first slice” move the handler so that a color filling half of the pie itself goes under and the other two colors show above that half. Step 5: Make sure Series options is highlighted. Right click and from the menu select format data series. Step 4: Click the pie once, all three quadrants will be selected. Step 3: Click legends once and press delete key. Time to modify it according to our requirements. You can see a pie chart in three colors with target, actual and variance plotted and on the right legends of what each color represent. Step 2: Go to Insert Tab > Charts group > click Pie drop down > Select the very first pie chart in 2-D Pie. Step 1: Select the data using Ctrl+A or using mouse. With a little more tuning to pie charts or dial charts we can make speedometer charts but this is for the future 😉 Making your first Pie Chart – Yummy! Variances can be negative or positive but for our chart we need a positive value in all the cases therefore we have wrapped the difference of two values in ABS function (absolute) to give us the positive value in all the cases. Target figures and actual figures are provided by us where as Variance figure gets calculated on its own as we have a formula in that case which as follows: All figures are expressed in percentages. With the same idea in mind we have the data of sales target and actual sales achieved so far in terms of target with variance. Sales manager mostly set benchmarks to track the progress. Usually sales department settle targets for the month and at certain of the week monitor the achievements. For the purpose of following tutorial and to best apply the technique discussed download this excel workbookand follow the steps mentioned below
0 kommentar(er)
