+ Reply to Thread
Results 1 to 1 of 1

Hide Trendline Error message/Hide Linear equation

  1. #1
    Registered User
    Join Date
    03-22-2018
    Location
    Australia
    MS-Off Ver
    2016
    Posts
    16

    Hide Trendline Error message/Hide Linear equation

    I'm having an issue with hiding the 'Trendline Error' message in my Graph.

    Previously never had this issue until today.

    Currently by default there is no X axis data (Heart Rate) (it requires 3 points to form an accurate linear equation).

    When I type in the 3 X axis Data (Heart Rate), it'll show the linear line as well as the equation. I know how to remove the equation from showing.

    When i remove the 3 axis data, the 'trendline error' message shows ups and when i type the X axis data in again, it'll show the linear equation again.

    Is there any way to fix this? to permanently hide the linear equation and the Trendline error message.

    Thanks.

    EDIT -: In case this would help.
    Excel Version: 2006 (build 13001.20266)
    Attached Files Attached Files
    Last edited by natkemon; 07-14-2020 at 02:40 AM.

+ 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. [SOLVED] Linear trendline:wrong equation
    By Jan M. in forum Excel Charting & Pivots
    Replies: 13
    Last Post: 09-28-2016, 02:09 PM
  2. [SOLVED] Incorrect Trendline Linear Equation
    By ossisuhonen in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-22-2016, 08:52 AM
  3. Replies: 5
    Last Post: 12-02-2013, 12:27 PM
  4. Scatter graph linear trendline and equation to find unknown
    By S_9 in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 05-09-2013, 08:26 PM
  5. Trendline Equation Error Wrong Y for Given X
    By billexchry in forum Excel General
    Replies: 2
    Last Post: 04-15-2011, 01:15 AM
  6. Replies: 3
    Last Post: 03-06-2011, 01:38 PM
  7. Linear Trendline Equation Question
    By QuestGAV in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-10-2005, 10:25 PM

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