How to add trendline to a chart?

Posted on April 10, 2010 by Sam

Take the following steps to add trendline to a chart:

  1. Click on the chart. The Chart Tools, adding the Design, Layout, and Format tabs appears.
  2. On the Layout tab, in the Analysis group, click Trendline.

    3. trendline

  3. Click More Trendline Options, and then in the Trendline Options category, under Trend/Regression Type, click the type of trendline. Select Moving Average and type the number of periods to use to calculate the moving average in the Period box.
Share

About Sam

I am an MCAS: Windows Vista, MCTS: Business Desktop Deployment, MCTS: Microsoft Office Project 2007. This blog is all about MCAS. I will be sharing information about MCAS exam. I am here to share information about different Microsoft exams. You all can ask questions from me about any certification exam and you can also share your experiences with me.
Posted in 77-603. Tags: . Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>