Graphing Question: Blank Lines Problem ?

Discussion in 'Excel Beginners' started by Bob, Oct 23, 2013.

  1. Bob

    Bob Guest

    Hello,

    Using Excel 2007.

    I have a graph (simple scatter) in which all the data points from a
    column are plotted vs dates. Seems to be what I want.

    But, I have some blank rows; nothing in any of the data cells for these
    rows.

    The graph just skips when it encounters these blank lines.

    How do I tell it to connect from the preceding line that has data, to
    the next line with data, so the graph looks continuous without these
    blanks ?

    thanks,
    Bob
     
    Bob, Oct 23, 2013
    #1
    1. Advertisements

  2. Bob

    Claus Busch Guest

    Hi Bob,

    Am Wed, 23 Oct 2013 15:19:57 -0400 schrieb Bob:

    > How do I tell it to connect from the preceding line that has data, to
    > the next line with data, so the graph looks continuous without these
    > blanks ?


    rightclick on your chart object => Select Data => Settings for hidden
    data or null values => Connect data points with line

    This suggestion doesn't work with all chart types


    Regards
    Claus B.
    --
    Win XP PRof SP2 / Vista Ultimate SP2
    Office 2003 SP2 /2007 Ultimate SP2
     
    Claus Busch, Oct 23, 2013
    #2
    1. Advertisements

  3. Bob

    Bob Guest

    For Claus B. Thank you. Re: Graphing Question:Blank Lines Problem ?

    On 10/23/2013 3:51 PM, Claus Busch wrote:
    > Hi Bob,
    >
    > Am Wed, 23 Oct 2013 15:19:57 -0400 schrieb Bob:
    >
    >> How do I tell it to connect from the preceding line that has data, to
    >> the next line with data, so the graph looks continuous without these
    >> blanks ?

    >
    > rightclick on your chart object => Select Data => Settings for hidden
    > data or null values => Connect data points with line
    >
    > This suggestion doesn't work with all chart types
    >
    >
    > Regards
    > Claus B.
    >
     
    Bob, Oct 23, 2013
    #3
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. ConfusedJulie

    Graphing in EXCEL

    ConfusedJulie, Jul 3, 2007, in forum: Excel Beginners
    Replies:
    1
    Views:
    96
    Bernie Deitrick
    Jul 5, 2007
  2. Jim
    Replies:
    2
    Views:
    86
  3. Carla Missouri

    How do I print lines in a blank workbook?

    Carla Missouri, Nov 22, 2008, in forum: Excel Beginners
    Replies:
    3
    Views:
    90
    AnotherNewGuy
    Nov 26, 2008
  4. Struggling in Sheffield

    Nested IF - return a blank when compared cells are blank

    Struggling in Sheffield, Feb 9, 2009, in forum: Excel Beginners
    Replies:
    2
    Views:
    116
    Pecoflyer
    Feb 9, 2009
  5. Paul Hood

    graphing

    Paul Hood, Apr 23, 2009, in forum: Excel Beginners
    Replies:
    1
    Views:
    79
    Paul Hood
    Apr 24, 2009
  6. Greygal

    Creating a summary page without blank lines

    Greygal, May 18, 2009, in forum: Excel Beginners
    Replies:
    1
    Views:
    85
    AltaEgo
    May 18, 2009
  7. Struggling in Sheffield

    Zero problem with blank cell after automated data transfer

    Struggling in Sheffield, Nov 5, 2009, in forum: Excel Beginners
    Replies:
    3
    Views:
    85
    Struggling in Sheffield
    Nov 13, 2009
  8. Bob

    Inserting Blank Lines ?

    Bob, Feb 11, 2011, in forum: Excel Beginners
    Replies:
    1
    Views:
    142
    Gord Dibben
    Feb 11, 2011
Loading...