+ Reply to Thread
Results 1 to 7 of 7

Help hiding zero value bars in stacked 3d bar chart

  1. #1
    Registered User
    Join Date
    08-08-2013
    Location
    Cambridge
    MS-Off Ver
    Win7 Office 2010
    Posts
    34

    Help hiding zero value bars in stacked 3d bar chart

    Hello all,

    I have a process flow excel spreadsheet showing times it take for processes to take place. I have a problem where I cannot seem to hide bars on my 3d stacked bar chart from showing zero value bars.

    I have attached a copy of the spreadsheet below CPH Purchase Order Process_7.1 (Recovered).xlsx

    Please have a look at the "Time Based Process Map" bar chart in the "Value Adding Flow Analysis" tab. Where there are zero values, I can't seem to hide the unwanted zero-value bars from showing. Is there a solution for this?

    Thanks,
    Chris

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

    Re: Help hiding zero value bars in stacked 3d bar chart

    you either need to filter the data table to remove zero items.

    Or more likely build a table of chart data that excludes zero items and then chart that instead
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    08-08-2013
    Location
    Cambridge
    MS-Off Ver
    Win7 Office 2010
    Posts
    34

    Re: Help hiding zero value bars in stacked 3d bar chart

    I've tried that and it does not work. Please could you show me?

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

    Re: Help hiding zero value bars in stacked 3d bar chart

    filtered table
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    08-08-2013
    Location
    Cambridge
    MS-Off Ver
    Win7 Office 2010
    Posts
    34

    Re: Help hiding zero value bars in stacked 3d bar chart

    Thanks but...that messes up chart. It should show a blank where the columns are zero, and not show the 'blue flecks' on the bar chart where zero values are

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

    Re: Help hiding zero value bars in stacked 3d bar chart

    if you just want to remove the bars rather than the Activity, which is what I thought you meant, use a 2d rather than a distorting 3d chart type.

  7. #7
    Registered User
    Join Date
    08-08-2013
    Location
    Cambridge
    MS-Off Ver
    Win7 Office 2010
    Posts
    34

    Re: Help hiding zero value bars in stacked 3d bar chart

    Ah, lovely! Thank you so much! All sorted! ^_^

+ 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] Multiple Bars - Stacked Column Chart
    By clarkerm in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-16-2013, 02:45 AM
  2. [SOLVED] compare stacked column bars in a chart
    By sarinky in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 03-29-2013, 02:21 AM
  3. How to chart 2 stacked bars per day?
    By Ingeniero1 in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 02-24-2009, 11:59 AM
  4. [SOLVED] Stacked bars in a gnatt chart
    By Gnatt in forum Excel General
    Replies: 1
    Last Post: 08-01-2006, 03:35 PM
  5. To create a stacked column chart and group the stacked bars togeth
    By Jacqueline in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-18-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