Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Jun 2005
    Thanked 0 Times in 0 Posts
    Can you please instruct me on how to add a trendline to the enclosed chart? Thank you for your time.[attachment=86451:Charts.xlsx]
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 28 Times in 28 Posts
    A cylinder chart isn't suitable for trendlines.
    I'd change the chart type to column chart.
    You can then right-click each of the series and select Add trendline from the popup menu.

    BTW, your chart series aren't quite correct - the names should come from row 2, and the data should come from rows 3:14.

    See the attached version (created in Excel 2002 so it won't quite match the colors used by Excel 2007)


    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts