Pivot Chart % Difference

When I create a pivot chart that charts the Year over Year Differences as calculated in a pivot table, the chart will show no bars for the first year, because it has no previous year to calculate the % difference from. Is there any way to remove this blank label from the chart? See the image below or the full spreadsheet in attachment.


Thanks,
David

Because you're using a % difference based on the prior year, I believe the first year needs to be there, even if it is blank.

If you were to move to Power Pivot, I'm thinking you could create a DAX measure that would allow you to show the values you want and suppress 2012 though.