+ Reply to Thread
Results 1 to 5 of 5

Dont show empty cells in chart

  1. #1
    Registered User
    Join Date
    04-22-2020
    Location
    Netherlands
    MS-Off Ver
    10
    Posts
    2

    Dont show empty cells in chart

    Hi everybody,

    I added an excel file with an example.
    I am struggling with the following...
    In the year 2016 you see that "Koek" and "Fruit" is empty.
    Still I am seeing them in the chart because there is a gap between the yellow and orange bar.

    Can someone help me with solving this??
    Thanks in advance.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Dont show empty cells in chart

    maybe if you use another graph type.

    see the attached file.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

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

    Re: Dont show empty cells in chart

    You would need to change the layout of your data, as per attached.

    Format the series to have 100% overlap.
    I have included multilevel category labels so the separation by year is more obvious.

    This style of cluster, where series points are removed, can make it difficult to interrupt do to the unmatched clusters.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  4. #4
    Registered User
    Join Date
    04-22-2020
    Location
    Netherlands
    MS-Off Ver
    10
    Posts
    2

    Re: Dont show empty cells in chart

    Thanks a lot guys!!!

  5. #5
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Dont show empty cells in chart

    Glad I could help.

    Thanks for marking the question solved.

    You can add reputation by clicking on the star * add reputation.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] To skip empty cells & show blank cells if #DIV/0! error
    By mikehk in forum Excel General
    Replies: 3
    Last Post: 07-22-2020, 03:23 AM
  2. Replies: 3
    Last Post: 02-21-2020, 12:30 AM
  3. [SOLVED] excel 2010 empty a cell according to other cells (without Deleting them just show empty)
    By pavlos_x in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-11-2015, 01:46 PM
  4. Replies: 3
    Last Post: 07-05-2009, 04:23 AM
  5. Replies: 2
    Last Post: 06-30-2009, 02:59 PM
  6. [SOLVED] dont show zero vaules in a chart
    By Donald Watkins in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-05-2006, 03:25 PM
  7. [SOLVED] Need cells to show as zero or empty
    By BelkyBear in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-07-2005, 04:45 PM

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