We won't use the histogram, as Excel doesn't allow to do histograms from pivot tables, we'll use the bar plot. Select Insert while the cursor is on the pivot table. In Values field configuration option (the small down arrow at right), select Count to get the frequency of values Pivot table field selection Put in columns the variable that's going to be the class, we'll use species.
From your data table, insert pivot table as new sheet Data table.To use Excel, try the pivot table option.
I will use the penguins dataset as example, as I don't have access to your data. Anyway, for the sake of answering, I offer my solution. I know it's an old one, surely you've found a solution time ago.
I just dropped by here and saw your question today.
