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:
    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.
     
    Claus Busch, Oct 23, 2013
    #2
    1. Advertisements

  3. Bob

    Bob Guest

     
    Bob, Oct 23, 2013
    #3
    1. Advertisements

Ask a Question

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.