Displaying Average value by category in bar chart

[newbie_sam]

Hi,

I have a columns of data that looks like this:

In my bar chart I want it to show the averages by these categories by Year, but the bar chart doesn't seem to be able to switch on row/column like excel does:

I want it to be able to show like this instead:

Any ideas?

[Greg_Deckler]

Switch your Axis with your Legend.

[newbie_sam]

How do I do that? 

I cant place more than 1 data field in the legend, so which data field should i pull to the legend? i'm puzzled, would be great if you can guide me through.

---

@smoupre wrote:

Switch your Axis with your Legend.

---

[newbie_sam]

Hi, when i pulled the "Year" to the legend, I can only add only 1 datafield into the bar chart..why?

[v-chuncz-msft · Accepted solution]

@newbie_sam,

You need to select Unpivot Columns in Query Editor first, then drag Attribute to Axis.

[newbie_sam]

Thanks I figure that out eventually! 🙂