Analyze Data - Help with Structuring Data to Improve Analysis

Hi skeskali,

You stated: "I'd like for the tool to show me the total of each class across each year in a graph, perhaps a stacked bar graph, or line graph, to indicate trends."

Just for the fun of it, and the only thing you have to change is switch the time periods and the category in your pivot table.  Have you tried putting the time periods in the ROWS, and the category in the Columns then make a graph out of it? Just wondering if you have tried that approach. Then a different graph for the location, the same approach or maybe the first value in the column would be the location, then category or probably even better, in the rows the first value would be the year, then location and in the column would be the categories. (recommended)

That approach might yield a graph chart that looks something like this:

cheers