+ Reply to Thread
Results 1 to 9 of 9

How to remove empty columns from the chart?

  1. #1
    Registered User
    Join Date
    10-21-2017
    Location
    Brasil
    MS-Off Ver
    2013
    Posts
    8

    Angry How to remove empty columns from the chart?

    Good afternoon.
    I have a problem and I could not find a way to reverse it.
    I have a Table where the Rows range from 1 to 8 and the columns are A, B, C.
    It turns out that A has value for all lines, but B only for Lines 1 and 2, and C for 3 to 8.

    I can not make a chart of it.
    I've done two different tables and excel does not understand me.
    The problem is that the returned graph has a gap, referring to the values of B for lines 3 to 8 and of C for lines 1 and 2, which do not exist.
    The images are shown below.

    TL;DR: I want two columns facing each number (1 to 8), but with 2 different colors for the second column of each number.
    1.PNG
    2.PNG
    3.PNG
    Attached Files Attached Files
    Last edited by bagwell351; 10-21-2017 at 02:37 PM.

  2. #2
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,749

    Re: How to remove empty columns from the chart?

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    sandy
    How to create an editor for Power Query with Notepad++ (tutorial)
    How to create timeline project with vertical today marker (2010, 2013, 2016 etc...) (examples)
    Tips for Excellent Spreadsheets

    What makes learning so hard is the amount of knowledge you have to unlearn
    Why is my program not doing what I expect?
    Because you set the wrong expectations. Rewire your brain

  3. #3
    Registered User
    Join Date
    10-21-2017
    Location
    Brasil
    MS-Off Ver
    2013
    Posts
    8

    Re: How to remove empty columns from the chart?

    Quote Originally Posted by sandy666 View Post
    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    Done, thanks.

  4. #4
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,749

    Cool Re: How to remove empty columns from the chart?

    Don't quote whole post!

    is that what you want?
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    10-21-2017
    Location
    Brasil
    MS-Off Ver
    2013
    Posts
    8

    Re: How to remove empty columns from the chart?

    Quote Originally Posted by sandy666 View Post
    is that what you want?
    Thanks for the help.

    In fact, what you did I did too.
    However, I did not like to put the C items as a secondary axis, getting over the other columns.

    Is there no way to leave the columns from 3 to 8, exactly the same as 1 to 2?
    I am with this level of detail because it is my research to finish my degree in engineering.

  6. #6
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,749

    Re: How to remove empty columns from the chart?

    AFAIK, you can't do that
    but you can try with this: Removing Gaps – Excel Clustered Column or Bar Chart

  7. #7
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,749

    Cool Re: How to remove empty columns from the chart?

    here is example, but only you know what you really need and how it should look
    Attached Files Attached Files
    Last edited by sandy666; 10-21-2017 at 05:52 PM. Reason: correction

  8. #8
    Registered User
    Join Date
    10-21-2017
    Location
    Brasil
    MS-Off Ver
    2013
    Posts
    8

    Re: How to remove empty columns from the chart?

    Quote Originally Posted by sandy666 View Post
    This is EXACTLY what I need. Thank you very much. I'll try.

  9. #9
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,749

    Re: How to remove empty columns from the chart?

    You are welcome

    If that takes care of your original question, & to say Thanks, please click on Add Reputtion (bottom left corner of the post of the person(s) who helped you)
    then select Thread Tools from the menu (top right corner of your thread) and mark this thread as SOLVED.
    If you did it - ignore it.
    Thank you.

+ 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. Macro VBA - Remove empty rows and columns with total deleted in msg
    By SmurofNeves in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-25-2015, 06:17 AM
  2. Aggregate data / remove empty columns
    By patapsco59 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-17-2014, 11:25 AM
  3. Remove whitespace from empty (non-existent) columns
    By throwaway992 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 12-20-2013, 12:17 AM
  4. [SOLVED] Remove Empty Rows ,Columns & Sort
    By johncena in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-18-2013, 03:40 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
  6. [SOLVED] How do I remove empty chart plots from linked worksheet charts
    By Lee IT in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 01-31-2005, 01:06 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