Results 1 to 3 of 3

How to add a trendline to a log graph when x=0?

Threaded View

  1. #1
    Registered User
    Join Date
    04-29-2021
    Location
    Kuala Lumpur
    MS-Off Ver
    365
    Posts
    2

    Question How to add a trendline to a log graph when x=0?

    Hello,

    I tried to plot my data (attached) and it looks like a log graph. I wanted to add a trendline, but it is not possible since the data starts at x = 0. At x = 0, it has a value (y-axis) and this is where the percentage of a substrate is 100%.

    How may I plot the graph if I want to have a trendline equation? Should I start plotting at the second reading i.e. after x =0? If so, how I may extend the trendline so that the y-intercept is the y-value of x = 0?

    Thanks for your response, I really appreciate it.
    Attached Files Attached Files
    Last edited by jz9; 04-30-2021 at 04:26 AM. Reason: Attach workbook

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Trendline Equation When Solved for X (as seen on graph) Does NOT Match
    By sundrop in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-11-2018, 10:49 AM
  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] How to link trendline equation in graph to cell?
    By rossgus in forum Excel General
    Replies: 1
    Last Post: 08-08-2005, 10:05 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1