2 Replies Latest reply on Feb 10, 2016 7:37 AM by David Trueblood

    Hide a single bar from a side by side stacked bar chart

    David Trueblood

      I have a stacked bar chart I created, that shows Total unique agents and New unique agents on a weekly basis.  The problem is with my first week.  It shows two bars:  total unique agents and new unique agents as the same (21), because there are no previous weeks to compare it to. From a calculation standpoint this is technically correct, but from a presentation standpoint it is a bit silly since it makes it appear that there are 42 agents that month when really there are only 21. 

       

      I have tried hiding the data in week one, but the problem is that it hides both sets of data (both bars) and makes the first week disappear off the chart completely.  I want to know if there is a way to hide just one of the bars for the week, or just make it 0.  Any help would be much appreciated.  Thanks.