+ Reply to Thread
Results 1 to 5 of 5

Remove chart column

Hybrid View

  1. #1
    Registered User
    Join Date
    08-02-2016
    Location
    Australia
    MS-Off Ver
    Office 365
    Posts
    9

    Remove chart column

    I have a simple bar chart (see attachment) and I would like to remove the 8th month without it affecting the rest of the chart. If I click on the filter and remove the 8th month it fills the whole chart with the 7 months which I don't want.
    Attached Files Attached Files
    Last edited by bondimedical3; 09-25-2016 at 02:47 AM.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Remove chart column

    Eh? It seems perfectly OK to me...
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU

  3. #3
    Registered User
    Join Date
    08-02-2016
    Location
    Australia
    MS-Off Ver
    Office 365
    Posts
    9

    Re: Remove chart column

    This is exactly what I didn't want. Maybe I didn't explain the question properly. I am making an animated gif and I am after 8 frames, 1 for each month so there can't be any changes to the graph other then the 8th column being removed.

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2406
    Posts
    44,662

    Re: Remove chart column

    woo Hoo. a 100% failure!!! Replace the data point you want hidden with a ? mark.

  5. #5
    Registered User
    Join Date
    08-02-2016
    Location
    Australia
    MS-Off Ver
    Office 365
    Posts
    9

    Re: Remove chart column

    That's nearly there. The only problem now is that the chart is scaling the bar columns upwards and there is also the number 0 in the 8th column
    Attached Images Attached Images

+ 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. Remove Duplicates in column and remove blanks
    By geliedee in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-13-2015, 07:25 AM
  2. How do you remove the gap between the y axis and first column in a chart?
    By dmasters4919 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-23-2015, 12:57 PM
  3. Remove gaps for missing values in column chart
    By Mthes in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-22-2014, 05:20 AM
  4. Replies: 2
    Last Post: 09-03-2013, 09:18 AM
  5. Chart - how to remove the date?
    By tavlrb in forum Excel General
    Replies: 1
    Last Post: 07-01-2011, 03:42 AM
  6. [SOLVED] zero value remove chart
    By Graeme in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 11-23-2005, 02:40 PM
  7. [SOLVED] How to remove 1 bar from bar chart??Thank you!
    By crossingmind in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-13-2005, 11:06 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