Results 1 to 8 of 8

Dliminate a slope on an Excel graph for values that have not yet been inputted (0 values)

Threaded View

  1. #1
    Registered User
    Join Date
    03-13-2024
    Location
    London
    MS-Off Ver
    Excel 365 - V16.79.2
    Posts
    16

    Dliminate a slope on an Excel graph for values that have not yet been inputted (0 values)

    Hi!

    I have an Excel graph that receives weekly data input. Currently, the graph simply reverts to 0 or the lowest value on the Y-axis for the next point yet to be inputted.

    Is it possible to hide the slope until data is inputted for the corresponding week?

    Picture of graph:
    Sk?rmbillede 2024-03-28 kl. 18.56.49.png

    Graph data:
    Sk?rmbillede 2024-03-28 kl. 18.34.47.png


    Each of the cells has a formula similar to this, only criteria and week can change. I tried using NA or "" to make the graph ignore the 0 values but no luck.

    =MAX(
    IF('Styrke, Uge 3'!B3="Comp Bench"; 'Styrke, Uge 3'!W3; 0);
    IF('Styrke, Uge 3'!B11="Comp Bench"; 'Styrke, Uge 3'!W11; 0);
    IF('Styrke, Uge 3'!B71="Comp Bench"; 'Styrke, Uge 3'!W71; 0);
    IF('Styrke, Uge 3'!B79="Comp Bench"; 'Styrke, Uge 3'!W79; 0);
    IF('Styrke, Uge 3'!B217="Comp Bench"; 'Styrke, Uge 3'!W217; 0);
    IF('Styrke, Uge 3'!B225="Comp Bench"; 'Styrke, Uge 3'!W225; 0);
    IF('Styrke, Uge 3'!B285="Comp Bench"; 'Styrke, Uge 3'!W285; 0);
    IF('Styrke, Uge 3'!B293="Comp Bench"; 'Styrke, Uge 3'!W293; 0);
    IF('Styrke, Uge 3'!B431="Comp Bench"; 'Styrke, Uge 3'!W431; 0);
    IF('Styrke, Uge 3'!B439="Comp Bench"; 'Styrke, Uge 3'!W439; 0);
    IF('Styrke, Uge 3'!B447="Comp Bench"; 'Styrke, Uge 3'!W447; 0)
    )
    Attached Files Attached Files
    Last edited by Excel_Struggler; 03-29-2024 at 01:39 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Slope function with two Y values for each X value
    By samhoare in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-23-2022, 06:30 PM
  2. Calculating a slope by the function and graph on a semi-log graph
    By ARGUANI in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 02-22-2014, 07:20 AM
  3. Get Y values from X values for a graph in excel?
    By tds019 in forum Excel General
    Replies: 0
    Last Post: 05-26-2011, 11:45 AM
  4. Count user inputted values
    By wildcats0625 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-11-2010, 11:21 AM
  5. [SOLVED] slope of data with the same y values
    By Rosa in forum Excel General
    Replies: 2
    Last Post: 01-02-2006, 09:35 AM
  6. Need to get slope of peaks on excel graph
    By Capillod in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 05-13-2005, 01:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1