+ Reply to Thread
Results 1 to 2 of 2

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

  1. #1
    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

  2. #2
    Forum Expert cbatrody's Avatar
    Join Date
    04-15-2014
    Location
    Dubai
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2,135

    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 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] 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. 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. 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1