+ Reply to Thread
Results 1 to 6 of 6

Second partial trendline appears on the beginning of the graph

  1. #1
    Registered User
    Join Date
    06-19-2021
    Location
    Germany
    MS-Off Ver
    MS Office Pro 2021
    Posts
    10

    Second partial trendline appears on the beginning of the graph

    Hi,

    I managed to get the one partial trendline on a graph through creating two different series for the same row data, but the problem is that the second line of data (green line) is appearing on the beginning of the graph, which doesn't make sense. Any solutions?
    Attached Files Attached Files
    Last edited by SvenBG; 07-02-2023 at 08:01 AM.

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Second partial trendline appears on the beginning of the graph

    Put the figures for the green trend line on a separate row and have the source from col C to AF. If you add =NA() to the cells that would be zeros then it won't plot those points so the trend line will appear where it should.

    BSB

  3. #3
    Registered User
    Join Date
    06-19-2021
    Location
    Germany
    MS-Off Ver
    MS Office Pro 2021
    Posts
    10

    Re: Second partial trendline appears on the beginning of the graph

    I did as you said, but if I set the source from C to AF then it shows me the trendline for the whole range, and when I change it to just that second part of the graph then it appears again on the beginning of the graph.

    P.S. the green line is no trend line, it is the graph line from which I want to pull the trendline.

  4. #4
    Forum Contributor
    Join Date
    09-03-2016
    Location
    Catania, Italy
    MS-Off Ver
    Excel 2019
    Posts
    164

    Re: Second partial trendline appears on the beginning of the graph

    HI
    you must enter the series from column C to column AF and where there is no data enter the formula =NOT AVAIL()
    See the attachment at row 11.
    HI,
    Mario
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    06-19-2021
    Location
    Germany
    MS-Off Ver
    MS Office Pro 2021
    Posts
    10

    Re: Second partial trendline appears on the beginning of the graph

    Hi Mario, that is also one step closer but still I cannot get the trendline for the second serie, without moving the graph line to the beginning. Checkt out the attachment:
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    06-19-2021
    Location
    Germany
    MS-Off Ver
    MS Office Pro 2021
    Posts
    10

    Re: Second partial trendline appears on the beginning of the graph

    P.S. maybe I should correct myself. The trendline is there, but it goes all the way from the beginning. Hm, I think I became little bit too petty/perfectionistic

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to add a trendline to a log graph when x=0?
    By jz9 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-02-2021, 08:53 PM
  2. Graph of three variables and trendline equation
    By suchitkolpe in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 06-18-2018, 10:11 AM
  3. Trendline in a stacked graph
    By seash in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 09-27-2016, 08:13 AM
  4. Trendline in graph
    By sumonrezadu in forum Excel General
    Replies: 2
    Last Post: 02-10-2009, 12:47 AM
  5. Trendline on stacked bar graph
    By Joni in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-19-2006, 03:40 PM
  6. Replies: 3
    Last Post: 01-26-2006, 12:15 AM
  7. [SOLVED] Adding a Trendline or similar to a 3D Column Graph
    By eXcellence in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-24-2005, 01:05 AM

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