How do I make these two pivot charts from this specific table? I can't figure it out, and this is a very common table format.

[PatrickJ]

I have a basic budget table below. The header row is the month, the first column is the category, and the intersection of these are values. I would like to make 2 pivot tables:

• The first pivot table will have the categories as the x axis, with all of the values of a month as the y values. This will track the spending in ALL the categories in a certain month.
• The second pivot table will have the month as the x axis, will all of the values of the categories as the y values. This will track the spend in ONE category over the entire year.

Below is the data and the two charts I am trying to make.

However, the only data that I can extract is the count per category, not value. As such, I can only produce a chart with the number "1" across all categories - because there is 1 piece of data per category.

Can someone direct me? This seems like it should be very simple but I, for the life of me, cannot figure it out.

 

[awoohaw]

Why do you have text "Data" in column D?

Is the crosstab report your raw data? Can you convert the data to a table and use slicers?
Have you considered unpivoting the data?

Have you looked into power query?