MULTI IN ONE: The Chart Title and Series Title

<div dir="ltr" style="text-align: left;" trbidi="on">
<div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;">
Your chart from the previous section should now look like this:</div>
<div align="center" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;">
<img alt="A 2D Bar Chart in Excel 2007" height="303" src="http://www.homeandlearn.co.uk/excel2007/images/ChartTypeBar.gif" width="494" /></div>
<div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;">
Once you have your chart in place, there are plenty of formatting options in Excel. In the chart above, for example, the title says "Chart Title". And there's a not terribly descriptive orange square that says "Series 1" (your bars may be blue). We'll see how to change that in a moment. But first, the Chart Title. (If you don't have a title in Excel 2010, select the first layout in the <b>Chart Layouts</b> panel.)</div>
<h3 align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;">
How to Change the Chart Title</h3>
<div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;">
To change the title of your chart, click on the title to select it:</div>
<div align="center" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;">
<img alt="Select the Chart Title" height="44" src="http://www.homeandlearn.co.uk/excel2007/images/chartFormatTitle.gif" width="123" /></div>
<div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;">
The circles surrounding the title tell you that it is selected. Once the title is selected, click on the letter "C" of Chart. Hold your left mouse button down and highlight the two words, as in the image below:</div>
<div align="center" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;">
<img alt="Highlight the text" height="45" src="http://www.homeandlearn.co.uk/excel2007/images/chartFormatTitle2.gif" width="124" /></div>
<div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;">
Once your title is highlighted, you can change it by simply typing a new one:</div>
<div align="center" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;">
<img alt="Type a new title" height="45" src="http://www.homeandlearn.co.uk/excel2007/images/chartFormatTitle3.gif" width="178" /></div>
<div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;">
While the title is highlighted, you can select a different font and font size, if you want (on the Home panel in the Excel Ribbon at the top.)</div>
<div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;">
To deselect the title, click anywhere outside of it.</div>
<h3 align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;">
Formatting a Series Title</h3>
<div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;">
To change the <b>Series 1 </b>text on the Chart heading to something more descriptive, select the title as you did above:</div>
<div align="center" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;">
<img alt="The Series Title" height="37" src="http://www.homeandlearn.co.uk/excel2007/images/chartFormatSeries.gif" width="73" /></div>
<div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;">
Make sure the circles are there, and then right click. You should see the following menu appear in Excel 2007:</div>
<div align="center" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;">
<img alt="Edit Data Source menu" height="164" src="http://www.homeandlearn.co.uk/excel2007/images/editDataMenu.gif" width="244" /></div>
<div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;">
Click on "Edit data source". Alternatively, click the <b>Edit data source</b> item on the <b>Data</b>panel on the Excel 2007 Ribbon:</div>
<div align="center" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;">
<img alt="Data Panel" height="85" src="http://www.homeandlearn.co.uk/excel2007/images/editDataPanel.gif" width="129" /></div>
<div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;">
For Excel 2010 and 2013 users, your menu looks like this:</div>
<div align="center" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;">
<img alt="Edit Data Source in Excel 2010" height="167" src="http://www.homeandlearn.co.uk/excel2007/images/2010/edit_data.gif" width="163" /></div>
<div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;">
The item to click on the menu above will say <b>Select Data</b> instead of <b>Edit Data Source</b>.</div>
<div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;">
In both versions you should then see the following dialogue box appear.</div>
<div align="center" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;">
<img alt="The Edit Data Source dialogue box" height="321" src="http://www.homeandlearn.co.uk/excel2007/images/editDataDB.gif" width="477" /></div>
<div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;">
The <b>Chart Data Range</b> at the top of the dialogue box is highlighting the cells A5 to B14. This is the data we selected for the chart. Below this there is an area for <b>Legend Entries (Series)</b> and <b>Horizontal Axis Labels</b>. We'll see more of these later. For now though, we just want to change Series 1 into something more descriptive.</div>
<div style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;">
So click on Series 1 to highlight it. Then click the Edit button, as in the image below:</div>
<div align="center" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;">
<img alt="Legend Entries" border="1" height="151" src="http://www.homeandlearn.co.uk/excel2007/images/editDataDBLegend.gif" width="285" /></div>
<div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;">
When you click the <b>Edit</b> button, you'll see a new dialogue box appear - <b>Edit Series</b>. It should look like this:</div>
<div align="center" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;">
<img alt="Edit Series" height="155" src="http://www.homeandlearn.co.uk/excel2007/images/editDataDBeditSeries.gif" width="320" /></div>
<div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;">
Notice the cells being referenced in the <b>Series name</b> area. They are cells A5 to B14. These same cells are also highlighted on the spreadsheet:</div>
<div align="center" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;">
<img alt="The cells for the Series" border="1" height="299" src="http://www.homeandlearn.co.uk/excel2007/images/editDataDBeditSeriesCells.gif" width="253" /></div>
<div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;">
Click on the BBC title instead, the one on Row 3 above. Your Edit Series dialogue box will have changed. The Series Name area will now say A3 (amongst all those dollars):</div>
<div align="center" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;">
<img alt="The cell reference has changed for Series name" height="155" src="http://www.homeandlearn.co.uk/excel2007/images/editDataDBeditSeries2.gif" width="320" /></div>
<div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;">
Click OK to get back to your <b>Edit Data Source</b> dialogue box. The Series legend will now say BBC:</div>
<div align="center" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;">
<img alt="The Legend Entries list has changed" height="320" src="http://www.homeandlearn.co.uk/excel2007/images/editDataDB2.gif" width="477" /></div>
<div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;">
Click OK to return to your spreadsheet. But look what's happened to the chart. <b>Series 1</b> has gone. Next to the orange square, we now have BBC 1:</div>
<div align="center" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;">
<img alt="The Series Legend now says BBC1" height="36" src="http://www.homeandlearn.co.uk/excel2007/images/editDataDB3.gif" width="65" /></div>
<div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;">
<br /></div>
<div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;">
We'll meet these boxes again when we create a chart from scratch. For now, let's see some more formatting option you can do with an Excel chart.</div>
<div align="left" style="background-color: white; font-family: Arial, Verdana, Geneva, Helvetica, sans-serif;">
<br /></div>
</div>

The Chart Title and Series Title

Your chart from the previous section should now look like this: Once you have your chart in place, there are plenty of formatting opti...