+ Reply to Thread
Results 1 to 2 of 2

Line chart - Omitting blank/zero cells in data range

  1. #1
    Registered User
    Join Date
    01-27-2010
    Location
    Rugby, England
    MS-Off Ver
    Excel 2000
    Posts
    1

    Cool Line chart - Omitting blank/zero cells in data range

    Typically Excel 2000 line charts seem to plot any data point that has no Y value (i.e. empty cell) as zero. Even with the settings in Tools>Options>Charts:Plot empty cells as... set to 'Not plotted (leave gaps)' the problem remains.
    Curiously however, when adding a second series to the line chart and plotting this on a secondary axis the problem (for this particular series) disappears.

    All data in this instance is entered manually in to the data ranges (i.e. the problem isn't to do with formula results etc) but I understand that the issue also occurs when the plotted data is calculated and the result is "0", " ", or "N/A".

    Has anyone got an explanation for this issue and/or had any comment from MS?

    Thanks.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,772

    Re: Line chart - Omitting blank/zero cells in data range

    Can you post an example of this.

    Are the cells really empty?
    Is the linke chart stacked?
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

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