+ Reply to Thread
Results 1 to 2 of 2

Can someone help me, so this wont plot empty cells in chart?

  1. 12-09-2015, 03:45 PM #1
    horsefish01
    horsefish01 is offline
    Forum Contributor
    Join Date
    05-20-2015
    Location
    Stockholm
    MS-Off Ver
    2013
    Posts
    307

    Can someone help me, so this wont plot empty cells in chart?

    So I don't want the blank ones to be chartet before I insert date+data!

    SheetsBD.xlsx
    Reply With QuoteRegister To Reply
  2. 12-10-2015, 03:26 AM #2
    cbatrody
    cbatrody is offline
    Forum Expert cbatrody's Avatar
    Join Date
    04-15-2014
    Location
    Dubai
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2,136

    Re: Can someone help me, so this wont plot empty cells in chart?

    Hi,

    To accomplish this you need to make the data source dynamic by defining 'Named Ranges'. See the following URL for steps involved:

    http://chandoo.org/wp/2009/10/15/dyn...t-data-series/
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Plot across empty values without plotting to zero-value on blank cells 1,2,3,-,-,6,-,-,9,-
    By Phil Thompson in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 04-06-2015, 06:47 AM
  2. Plot gaps when cells are empty
    By jmamendes in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 08-30-2013, 05:14 AM
  3. Excel 2010 - X Y scatter plot will not plot empty cells as gap
    By bjeffers0306 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-12-2013, 12:56 AM
  4. Macro starts chart but wont plot data
    By wizgf19 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-17-2008, 11:08 AM
  5. plot empty cells as interpolated
    By roly in forum Excel Charting & Pivots
    Replies: 11
    Last Post: 04-23-2007, 07:06 PM
  6. [SOLVED] If I do not plot empty cells, how do I change the category axis?
    By Andrew Edmonds in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 08-02-2006, 11:45 AM
  7. [SOLVED] Plot empty cells as: Interpolated
    By Jaco in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-14-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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1