XP
Excel 2010
Hi All,
I am unable to use Slicers for a certian project, so when I created my pivot table and pivot chart with a basic filter, I do not want all the fields in the pivot chart that are in the table. I can not figure out how to remove data field from the pivoct chart without it removing from the pivot table.
All together i have 3 columns of values - mean score, sum of surveys received and
ranking in my pivot table. I only want the Mean score to display in the pivot chart.
Any suggustions would be greatly apprecited.
Thanks
Terry
Excel 2010
Hi All,
I am unable to use Slicers for a certian project, so when I created my pivot table and pivot chart with a basic filter, I do not want all the fields in the pivot chart that are in the table. I can not figure out how to remove data field from the pivoct chart without it removing from the pivot table.
All together i have 3 columns of values - mean score, sum of surveys received and
ranking in my pivot table. I only want the Mean score to display in the pivot chart.
Any suggustions would be greatly apprecited.
Thanks
Terry