In the attached spreadsheet, you'll notice that my pivot chart is plotting the same number more than once, because the numbers appear more than once in the field list which it is pulling from.
The data source is a column containing hundreds of the numbers you see plotted, but I only want an average of each. After going through all of the numbers in the original set of data, there are no inconsistencies that I can find (i.e., nothing is misspelled, there aren't any spaces before or after the numbers).
What could be causing the field list to populate some of the numbers more than once? Is it a problem with the original data or with the pivot table/chart?
Bookmarks