+ Reply to Thread
Results 1 to 3 of 3

Remove whitespace from empty (non-existent) columns

  1. #1
    Registered User
    Join Date
    12-18-2013
    Location
    Spain
    MS-Off Ver
    Excel 2013
    Posts
    3

    Remove whitespace from empty (non-existent) columns

    In Excel2013, I'm trying to generate a graph from this table.
    8MDLnAv.jpg

    It turns out like this.
    ujTHviH.jpg

    This is almost what I need however there is an unnecessary whitespace for every blank cell. It's more obvious when you look at the ref bars. I suppose Excel is creating a column of height 0 for every blank cell. I really need to change this behaviour and remove those empty columns.

    Can somebody help me?

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    11,469

    Re: Remove whitespace from empty (non-existent) columns

    To attach a Workbook
    (please do not post pictures of worksheets)
    • Click Advanced (next to quick post),
    • Scroll down until you see "Manage Attachments",
    • Click that then select "add files" (top right corner).
    • Click "Select Files" find your file, click "open" click "upload"
    • Once the upload is completed the file name will appear below the input boxes in this window.
    • Click "Done" at bottom right to close the Attachment Manager.
    • Click "Submit Reply"
    Ben Van Johnson

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    51,261

    Re: Remove whitespace from empty (non-existent) columns

    Hi and welcome to the forum

    If the data you are plotting is from a formula, modify the formula to produce #N/A for the blank cells.

    Either that or hide the rows with the blank cells
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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] Remove Empty Rows ,Columns & Sort
    By johncena in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-18-2013, 03:40 AM
  2. [SOLVED] remove whitespace or tabs
    By nikko50 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 02-13-2013, 10:28 PM
  3. remove non-existent space in front of text in excel
    By ewong in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-27-2012, 12:30 PM
  4. Add and Remove the Fields in an existent Pivot Table through VBA
    By RagonichaFulva in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-24-2012, 10:15 AM
  5. Help remove the empty columns or rows
    By SimonLee in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-20-2011, 11:20 PM

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