Pivot Table displaying incorrect data

[laurgal]

Hello.  I am trying to create a pivot table to create a histogram comparison for my data.  When I create the pivot table, the column headers populate accurately, however the data within is not completely correct.  Only two columns are accurate, while the other 4 are displaying data from one set of data.  In my screenshot, Count of Cycle 1 and Count of Cycle 5 are correct, but Cycles 3, 7, 9, and 10 are displaying data for Cycle 1 instead of their own information. How do I fix this?

[#2]

@laurgal You don't show the underlying data, but I suspect that all cells with cycle values contain something and thus get counted. For instance, if these values are populated by a formula to contain "" to shows as a blank, these cells will still be counted in a pivot table.