Microsoft Excel 2007 to 2010

The Chart Layout Panels

In the previous part of this lesson on charts, you saw how to format a chart with various dialogue boxes.

You can also format your charts using the menu items on the Excel Ribbon bar, at the top of the screen. With your chart selected, click the Layout menu. You should see this:

The Layour menu is a bit big for this pages, so we've split it in two. But the chart Layout panel is split into a number of different section (six in our version), and allows you to change the information in the chart. The first thing you may want to do is to give your chart a name.

To change the name of your chart, locate the Properties panel on the Layout menu:

Highlight the default name in the textbox and type a new one:

If you now click away from your chart, and then click back on it, you'll notice the name of the chart change:

The Labels Panel in Excel 2007/2010

The Labels panel on the Layout menu lets you format the titles and legends on your chart. Here it is:

The first one is Chart Title. Click the down arrow to see the options:

Click each item on the menu in turn to see what they do. Then click More Title Options. The following dialogue box will appear (Excel 2010 has more options):

As you can see, there are options to change the Fill, Line, Line Style, Shadow, 3-D format, and Alignment. Play around with the options on the dialogue box to see what they do. The only thing you're changing here is the Chart Tile. Click Close when you're done. If you don't like what you see, click the undo arrow at the top of Excel.

Change the Axis Title in Excel 2007/2010

The next item on the Labels panel is the Axis Title. Click the down arrow to see the options:

At the moment, our chart has no Axis Title. It just has numbers running across the bottom. Someone looking at the chart won't know what the numbers represent. Here's what our Chart looks like at the moment:

To add an Axis title, click on Primary Horizontal Axis Title. From the sub menu, clickTitle Below Axis.

When you click Title Below Axis, a new title will be added to the chart:

Highlight the default text, and type your own:

Click away from the chart to see what it looks like:

We now have some explanation for what the numbers represent. You can add a Vertical Axis, as well. Click on Primary Vertical Axis Title and see how it works.

Chart Legend

The Chart's Legend is this one:

At the moment, out Legen is on the right of the chart. But you can move this. Click the Legend item on the Layout panel to see the various options:

Click an option on the menu and watch what happens to your Legend. You should see it move around your chart.

Adding Data Labels to an Excel Chart

A Data Label is information overlaid on the chart bars. In our chart below, we have numbers overlaid on the orange bars:

You can format these Data Labels. Click the Data Labels item on the Labels panel to see the following options:

The one highlighted is what we have at the moment. Click on Outside End and your Data Labels will look like this:

You can also see the options if you click More Data Label Options from the menu. You'll then see this dialogue box:

Again, play around with the options to see what they do. The first two, Label Options and Number, are the ones you'll probably use most often.

In the next part, we'll take a look at the Format Chart panels in Excel . You can create some impresive looking charts very quickly on this panel!