create line chart of specific column in pivot table chart

[Thanish]

Team, I have raw data of individual volume sold on a daily basis. I updated Pivot based on month, volume sold and hc involved. I added a "Calculated Field" as production% based on a formula of volume divided by HC involved. Now the challenge is that, i need the pivot line chart for production% only whereas excel gives the pivot chart for volume, hc and production%. Is there any solution to this.

Month	Volume	HC	Production%
Aug	2622	285	61%
Sep	3606	271	89%
Oct	3120	257	81%
Nov	3130	256	82%
Dec	2636	249	71%
Jan	2400	228	70%
Feb	2918	223	87%
Mar	3549	215	110%

 

[RoryA]

Not with a pivot chart, no. You'd need to either change the pivot to only show the data you want on the chart, or create a normal line chart using the relevant column from the pivot table, though that can be tricky to keep up to date.