Bar Charts and data points with "zero" value

[schardt]

Hello!

I'm in a bit of a pickle. I normally can answer most of the Excel questions that come my way, but I'm not sure of how I can do this.

Using Excel 2010, I have a pivot table that is pulling information from a raw data set. Some of the pivot table does not have a value, and shows a gap in the bar chart. See picture.

Is there a way to collapse the pivot bar chart so if the value in the pivot table is zero, there is no space? This isn't a gap width issue (already tried that) as that will still show a space for the missing data bars. If possible, would prefer a solution that does not require a macro.

 

[Asala42]

I don't think there is a way, as bar charts will always make room for each series.

Now, you may want to simply work around the issue by using a stacked bar chart instead. Just another way to display the data that would be fairly clean and lined up. Another way would be make the series line charts - just remove the lines and leave the data points. At least that would be my approach.

 

[schardt]

Thanks, Asala42. I'll pass this along to my customer.