Okay so I have a column of numbers as a field in a pivot table (board names). I am trying to figure out a way for the pivot table to treat each row of data as absolute. The problem is when I use the board names as a field in the pivot table, it groups these board names together and it messes up the integrity of my chart. So for instance board name: 123456 may appear 7 times in my data set, however when I go to make a chart about those 7 different boards, it recognizes them as the same thing. So my question is how do create a chart on the pivot table that will allow to put my board name field on my chart without excel grouping the board names together?
Bookmarks