Chart from Pivot Table problem
Posted by DAS on October 12, 2001 2:15 PM
I have a pie chart produced from a simple pivot table with data in following format:
DATE:(drop down menu)
|Status|% of total|
Grand Total 100%
Problem: When I change the date with drop down menu, there is the possibilty that one of the status'(A,B,C OR D) won't be in the data set and this moves grand total up one row. Now grand total is included in pie chart. Tried taking grand total out of options, but then I get error message for %'s. I do not want Grand Total to show up in chart......HELP.