Is there a way of including the Pivot Table grand totals in a chart that you create from the pivot table?
I have data per Department on a question with count of answers for "Agree" "Disagree" "Not Sure" and I need to display the total per department that completed the question. ie 1 agreed, 2 disagreed and 3 were not sure, therefore total must display as 6 for that department in the graph,
Please help!!!!!