Graphing Question: Blank Lines Problem ?

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

  1. Bob

    Bob Guest


    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

    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 ?

    Bob, Oct 23, 2013
    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

    Claus B.
    Claus Busch, Oct 23, 2013
    1. Advertisements

  3. Bob

    Bob Guest

    Bob, Oct 23, 2013
    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.