Using trend lines and error bars


show more Using trend lines and error bars provides you with in-depth training on Business. Taught by David Rivers as part of the Numbers '09 Essential Training show less
please wait ...

Using trend lines and error bars

Trend Lines and Error Bars in a chart can add additional information to what's already displayed. We'll begin with trend lines, which can help you to see trends in your data. Now, these lines are calculated and drawn to fit your data according to the type of equation you prefer. Let's use the Utility Cost chart in our Energy Saving Plan spreadsheet. The first step is to select the chart. Now, we'll go to the Chart Inspector, click the Inspector button on the Toolbar, make sure that Chart Inspector is selected, the Series button, and now we'll open up the Advanced section by clicking the disclosure triangle next to Advanced.

Here's where we'll find the Trendline button, and now to show a trend line say for the year 2008, we simply select any of the bars for 2008. This selects the entire series. We'll go back to the Chart Inspector now, and you'll notice under trend line that None is the default. But when we click the button, we see a list of trend li...

Using trend lines and error bars
Video duration: 5m 21s 3h 53m Beginner

Viewers:

Using trend lines and error bars provides you with in-depth training on Business. Taught by David Rivers as part of the Numbers '09 Essential Training

Subject:
Business
Software:
Numbers
Author:
please wait ...