create a chart with a benchmark line in excel for mac

Create A Chart With A Benchmark Line In Excel Mac Offers Real

Create A Chart With A Benchmark Line In Excel Mac Offers Real

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.

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.

One way you can use a combo chart is to show actual values in columns together with a line that shows a goal or target value.

The trick is to plot just one point in the XY scatter chart, then use error bars to create a continuous line that extends across the entire plot area.

We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.

Create A Chart With A Benchmark Line In Excel For Mac