How to customise the chart title in Excel charts and graphs
Let’s now look at the Chart Title and what we can do with that. If I right click on it and I go to Format Chart Title, you’ll see for the most part, the options available are exactly the same as the Chart Area and a number of different areas in the chart – so we can change the Fill, Solid, Gradient, etc. The Border Colour, the Border Styles, Shadow, 3D Format.
The new option here is something called Alignment. What this allows you to do, is to align what way the Title must lie. So depending on how big your Chart Title Area is, you can choose what to appear on the top, middle, bottom, etc. All these options exist. The text direction allows you to change the direction of the text so at the moment we have got it horizontal – that way. Let’s make it 90 degrees so you’ll see you push it down that way. Maybe you would prefer it that way or perhaps stacked like that. We are back to horizontal and you’ll see we can actually do a custom angle. So you can see as I change these the graph is changing. Let’s go back to zero. Depending on what you have chosen as well, some of these might become available so you can Autofit, change the margins, etc. So that’s the only real new thing available under the Chart Title.
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
I actually told Gavin this morning that I want to send you an e-mail. It was excellent. I have personally asked most of the people who were there what they thought about it, and everybody was really positive and confirmed that they learned a lot.– Melco Conveyor Equipment (Pty) Ltd