How to create an excel chart template to re use on a regular basis
When you spend hours trying to get a graph to look just the way you want it, it can be disheartening to know that next month, when you get a new set of data, you are going to have to go through the entire process again. This is where the Excel Chart Template come into play. Here we have a chart and let’s say this is the way it is required to be and you’ll see we have done 3D and we have put a few labels and changed a few colours, etc.
If I go to the Chart Tools Ribbon, you’ll see I have got something here called “Save as Template”. When I click this, all it asks me is “Give me a Name” so I am going to come here and say let’s call this “Video Clips” and I save it. So nothing much seems to have changed. Let’s click out of it, go here and go to Create a New Chart – go to Column 1 and we try and find the closest match and you’ll see even that is not what we’ve done previously. We’d like this to convert and look like that – simple enough- you can now click on the chart – you can say Change Chart Type and you’ll notice at the top here there is something called Templates. When I click on it, there are various options and you’ll see if you hover over them the name appears. There is the one we were looking for, I click on it, say OK and the format of this chart will go back to exactly the format that we had set up before. This is ideal if you have data coming to you once a month and you don’t want to have to go through this process every time.
Advanced Excel Course – June 2013 in South Africa Our next advanced excel course is running during June 2013 in Johannesburg. During the week of the 10th June we offer the following options. You can either attend the full 5 … Continue reading
A very popular chart is the waterfall chart which shows the impact of various items on a total e.g. the various components that explain the move from budgeted profit to actual profit. A common way to build this is using … Continue reading
“Data accuracy and consistency has improved dramatically across Absa Capital, so much so that it has become compulsory within certain areas for all staff to complete Adrian’s Data Analyses Spreadsheet Techniques course.”– Absa Capital