Pivot table and chart

[nparsons75]

I have a pivot table with 4 columns of data. I want to create a pivot chart but only show 2 of the columns data on the chart, is this possible?

 

[RoryA]

Only if you hide the columns in the pivot. The two are always in sync.

 

[nparsons75]

that should be ok but the 2 other columns are only there to perform calculation to get the final result, which will be charted. If I hide them with the calculation still happen?

 

[RoryA]

If the calculation is done inside the pivot using calculated fields, then yes.

 

[nparsons75]

great, yes they were calculated fields I added, thank you.