Last time I explained how to update automatically a trend chart using name manager in an excel report so now, I will do for a pie chart because it is quite similar but different.
It is very useful if you want to save time because if you don’t do that, each time you put the new data for the new month, you will have to update the chart after so making the chart to be updated automatically, it is a quite nice.
To explain better, I will use those data:
So this is how I do it:
1. Click on “formulas -> name manager”
2. Click on “new” to get this box:
3. Put a name in the “name” field (for instance “month”) and put this formula in “refers to” field:
4. Close the “name manager” and select your chart then click on “design -> select data”
5. Select the month and click on “edit”
6. In “series values” field, put:
7. Click “OK” and “OK” again. Take note that if you click again in “edit”, the name will be changed from the sheet name to the excel name.
8. Now, select 1 cell and put this formula:
9. Select the title of your chart and in the formula bar, put:
10. Now if I put the new data for the month of March, the chart will be update automatically including its name.
If you want to customize the title of your chart, for instance, instead to put only “march”, you want to put “SLA results for March”. In this case, read my topic Mix text and formula into a cell with a formula in an excel report.
When you are managing a team, “how to be a good manager” is the “must”...
As manager, I am doing many reports, even when I was an ITIL consultant, I still needed to do many reports...
ITIL V3 is going to be obsolete...
Managing an IT service when I start a new company is not an easy task, particularly true, if the service...