Results 1 to 6 of 6

plot graph without blank values

Threaded View

nielsb plot graph without blank... 02-26-2023, 01:45 PM
TMS Re: plot graph without blank... 02-26-2023, 02:03 PM
nielsb Re: plot graph without blank... 02-26-2023, 02:34 PM
TMS Re: plot graph without blank... 02-26-2023, 03:05 PM
nielsb Re: plot graph without blank... 02-26-2023, 04:09 PM
TMS Re: plot graph without blank... 02-26-2023, 04:19 PM
  1. #1
    Registered User
    Join Date
    03-13-2012
    Location
    Deventer, Netherlands
    MS-Off Ver
    Excel 2010
    Posts
    64

    plot graph without blank values

    Hi there,

    I?m trying to obtain a plotted graph from a dynamic range (attached file, tab "SELECT") which is derived from another tab (tab "INPUT".
    The cells with ?? as value (e.g. H19) are plotted by Excel as 0, whereas I want Excel to neglect them (not plotted in the graph).

    Deleting the formula from the cells would do the trick, but I don?t want that as the graph need to be used for dynamic inputs

    Does anybody know how to overcome this?

    Kind regards,
    Niels
    Attached Files Attached Files
    Last edited by nielsb; 02-26-2023 at 04:10 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 4
    Last Post: 12-24-2014, 07:24 PM
  2. [SOLVED] Dynamic Graph, Do Not Want X-Axis to Plot Blank or Zero Values New version
    By Kartoffelmos in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 10-21-2014, 12:58 AM
  3. How to plot no values in a bar graph
    By josephn in forum Excel General
    Replies: 3
    Last Post: 06-03-2014, 04:01 PM
  4. [SOLVED] Want graph not to plot 0 values
    By wolfgang713 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-14-2013, 09:07 AM
  5. [SOLVED] Dynamic Graph, Do Not Want X-Axis to Plot Blank or Zero Values
    By TEBrown in forum Excel Charting & Pivots
    Replies: 12
    Last Post: 04-11-2013, 05:08 AM
  6. Generating Values from a Graph Plot
    By feenix in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 01-18-2007, 02:35 PM
  7. Can you plot a graph with 3 axes e.g. xyz values on Excel?
    By Khan in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-29-2005, 09: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