Hi Mynda,
I have a pivot table where I have used "% Difference From" to show the variance from previous year. When I chart this, I am seeing the previous year in the chart, which is obviously all blank. How can I hide the base year from the chart so that I only see the difference columns?
tnx
Tracy
Hi Tracy,
You can't with a Pivot Chart. Basically what you see in the PivotTable gets plotted in the Pivot Chart and you need the base year for the % Difference From.
The workarounds/options are to use Power Pivot PivotTables and charts which allow you to write measures for the % Difference From calculation that doesn't require the Previous Year data in the PivotTable itself. Or, create a regular chart from the PivotTable as described here, which allows you to exclude certain columns.
Mynda
Thanks Mynda, I will try writing a measure in powerpivot, but still busy with the course.
