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?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. ConfusedJulie

    Graphing in EXCEL

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

    How do I print lines in a blank workbook?

    Carla Missouri, Nov 22, 2008, in forum: Excel Beginners
    Replies:
    3
    Views:
    78
    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:
    102
    Pecoflyer
    Feb 9, 2009
  5. Paul Hood

    graphing

    Paul Hood, Apr 23, 2009, in forum: Excel Beginners
    Replies:
    1
    Views:
    71
    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:
    75
    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:
    69
    Struggling in Sheffield
    Nov 13, 2009
  8. Bob

    Inserting Blank Lines ?

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