With a little more tuning to pie charts or dial charts we can make speedometer charts but this is for the future □ Understanding the workaroundĪs I said earlier there is no feature in Excel that let you do conditional charting, although there is conditional formatting but that is limited to cells. And if actual sales exceed 50% then show the graph in green or blue color. But today we are adding a little twist to it. What we want to do is let’s say if actual sales are less than 50% of standard or target then graph should be in red color. This is the same concept we utilized to make dial charts. 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. Usually sales department settle targets for the month and at certain day of the week supervisor 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 Comments
Leave a Reply. |