+ Reply to Thread
Results 1 to 2 of 2

Remove gaps for missing values in column chart

  1. #1
    Registered User
    Join Date
    05-20-2014
    Posts
    1

    Remove gaps for missing values in column chart

    I have searched the forum for help to remove gaps for missing values in my column chart. I have tried to adjust series overlap and gap width, but the missing values are still showing as gaps. Any idea on how to solve this issue? I have attached the sheet and would appreciate if anyone would have time to have a quick look at it.
    Attached Files Attached Files

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

    Re: Remove gaps for missing values in column chart

    Should it really be removed? Just because nobody answered "Very Good" does not mean you should not show that.

    Anyhow if you want to remove the category the quickest way is to hide that row of data.

    Other than that you need to build a concatenate range of data for the chart and use dynamic ranges to alter the categories used.
    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)

Similar Threads

  1. [SOLVED] Removing gaps in column chart for missing data
    By WiscoEm in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 02-18-2014, 08:10 PM
  2. Replies: 2
    Last Post: 09-03-2013, 09:18 AM
  3. [SOLVED] Clustered Column Chart - Removing Gaps for Zero Value Series
    By rzrbkpk in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 08-30-2013, 11:02 AM
  4. [SOLVED] Get values in continuous cell from a column with gaps
    By shawpnik in forum Excel General
    Replies: 2
    Last Post: 05-28-2012, 02:07 AM
  5. I get gaps in bar chart when using weekday values only in x-axis
    By Björn Elfvin in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-01-2005, 10:06 AM

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