The Axis Titles of both, the horizontal and the vertical axes appear and are highlighted.

When the text on the worksheet changes, the axes titles also change accordingly.

Select the worksheet cell that contains the text that you want to use for the axis title.

When the text on the worksheet changes, the chart title also changes accordingly.

Select the worksheet cell that contains the text that you want to use as the chart title.

However, we cannot make out the percentage contribution of each.

The horizontal axis is replaced by the header row of the data table.

For example, you can show 5 positive and negative potential error amounts in the results of a scientific experiment.

Elements For Charts Excel Mac Ribbon Displays

When you click anywhere on a chart, the Office 2011 for Mac Ribbon displays three tabs from which to choose.

This Ribbon tab has chart types, quick layouts, chart styles, sparklines, and data source controls.

Here you find a selection indicator and chooser, selection formatting options, analysis options, label options, and 3-D rotation options.

All the formatting options adjust automatically to activate only those options that are applicable to whatever is selected.

Selection indicators display on the chart series elements in the chart.

The corresponding row or column in the data source is not deleted.

The formatting options work the same in charts as for other objects.

Each button lets you choose from a pop-up menu of position and formatting options.

You can choose whether or not to have a label on your chart at all; you can choose No Chart Title, for example.

The final option in each menu displays a dialog with precision control over the chart element being formatted.

To do so, click the Axes button in the Axes group of the Chart Layout tab of the Ribbon.

You can set the unit of measurement and switch from scalar (the default) to log scale using the Axes button.

The final option in each buttons drop-down menu displays a dialog with precision control over the axis being formatted.

His business is creating professional presentations and templates, and he manages the PowerPoint sites indezine.com and ppted.com.

James Gordon is a Microsoft MVP for Macintosh, creator of the InsertPicture add-in for Mac PowerPoint, and an Office trainer.