+ Reply to Thread
Results 1 to 3 of 3

Adding Trendline To Just Some of the Bars in Chart

  1. #1
    Carroll
    Guest

    Adding Trendline To Just Some of the Bars in Chart

    Is it possible to add a trendline to just some of the bars in a chart?
    Suppose each bar represents a month, and you wanted to just show a
    trendline beginning with a month that wasn't the first month in the
    chart. Is this possible?

    Thanks,

    Carroll Rinehart


  2. #2
    Tushar Mehta
    Guest

    Re: Adding Trendline To Just Some of the Bars in Chart

    Add the desired points as another data series and have XL calculate the
    trendline for this series. You can always format the series so that it
    appears invisible.

    --
    Regards,

    Tushar Mehta
    www.tushar-mehta.com
    Excel, PowerPoint, and VBA add-ins, tutorials
    Custom MS Office productivity solutions

    In article <[email protected]>,
    [email protected] says...
    > Is it possible to add a trendline to just some of the bars in a chart?
    > Suppose each bar represents a month, and you wanted to just show a
    > trendline beginning with a month that wasn't the first month in the
    > chart. Is this possible?
    >
    > Thanks,
    >
    > Carroll Rinehart
    >
    >


  3. #3
    Carroll
    Guest

    Re: Adding Trendline To Just Some of the Bars in Chart

    Thank you Tushar.

    Carroll


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1