+ Reply to Thread
Results 1 to 4 of 4

How to combine multiple trendlines in a single chart?

  1. 02-15-2014, 09:43 AM #1
    snowbell
    snowbell is offline
    Registered User
    Join Date
    02-15-2014
    Location
    Dhaka, Bangladesh
    MS-Off Ver
    Excel 2013
    Posts
    2

    How to combine multiple trendlines in a single chart?

    I'm new in here and I love the forum already! I'm stuck with a problem now. I am doing financial ratio analysis of a company for five years and I need to show the ratios in a trendline. I have generated seperate line charts for each ratio, but I want to combine the charts and have multiple trendlines for multiple data series in a chart. Is this possible? Any help is much appreciated.

    I'm not really proficient in excel, so please explain your answer fully. I know I am asking for a lot, but I am really desperate for a solution. This is driving me crazy!!
    Reply With QuoteRegister To Reply
  2. 02-16-2014, 12:19 AM #2
    MrShorty
    MrShorty is offline
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP, 2007, 2024
    Posts
    16,357

    Re: How to combine multiple trendlines in a single chart?

    If I understand what you are trying to do, then yes, it can be done. Can you clarify something? Are you trying to create a chart where you have multiple data series and a trendline for each data series? or are you trying to combine everything into one chart, then have a single trendline based on all of the data series?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.
    Reply With QuoteRegister To Reply
  3. 02-22-2014, 03:56 AM #3
    snowbell
    snowbell is offline
    Registered User
    Join Date
    02-15-2014
    Location
    Dhaka, Bangladesh
    MS-Off Ver
    Excel 2013
    Posts
    2

    Re: How to combine multiple trendlines in a single chart?

    Hi,

    sory I didn't respond earlier, my internet was was cut! I have multiple data series and I want separate trendline for each data series, not a combined one. Thanks for your response.
    Reply With QuoteRegister To Reply
  4. 02-22-2014, 11:26 AM #4
    MrShorty
    MrShorty is offline
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP, 2007, 2024
    Posts
    16,357

    Re: How to combine multiple trendlines in a single chart?

    Start by adding multiple data series to a given chart: see adding data to an existing chart here: http://office.microsoft.com/en-us/ex...980.aspx?CTT=1 and/or here http://office.microsoft.com/en-us/ex...310.aspx?CTT=1

    Once all the data is added to the chart, then add the trendlines: http://office.microsoft.com/en-us/ex...798.aspx?CTT=1

    It should be that easy. Let us know if you get stuck.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Combine 2 named-ranges for a single series line chart
    By ElmerS in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 12-02-2014, 07:21 PM
  2. How to combine multiple rows of data into a single row (with multiple columns)?
    By probeen in forum Excel General
    Replies: 6
    Last Post: 02-19-2014, 10:25 AM
  3. multiple data sets in a single chart - need a single legend entry/color
    By mrjimmy in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-15-2013, 08:50 AM
  4. [SOLVED] Change multiple trendlines on one chart
    By jeffreybrown in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-04-2012, 07:57 AM
  5. Combine candle and line in a single chart
    By Bert in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-20-2005, 10:06 AM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1