Excel 2011 for Mac offers real power in its chart-analysis tools, but using them requires some knowledge of the math behind the features.

Using a single data series makes your chart much easier to understand.

To add a trendline, choose the Trendline option from the Chart Layout tab of the Ribbon.

This brings up the Trendline gallery with options to choose from.

In the Chart Layout tabs Analysis group, choose LinesHigh-Low Lines to add these.

On the Ribbons Chart Layout tab, go to the Analysis group and click UpDown Bars to turn these on or off.

Double-click one of the bars to display the Format Up Bars dialog, where you can customize these bars.

You can specify custom error values by clicking the Specify Value button and choosing cells.

How Do I Find $1$1 On Excel Professional Presentations And

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.

Although Apples iWork also does the job and allows you to easily import and export.xls files.

How Do I Find $1$1 On Excel For Mac