Forum Discussion

newbie_sam's avatar
newbie_sam
Frequent Visitor
9 years ago
Solved

Displaying Average value by category in bar chart

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?

Need Help

5 Replies

    • newbie_sam's avatar
      newbie_sam
      Frequent Visitor
      9 years ago

      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's avatar
        newbie_sam
        Frequent Visitor
        9 years ago

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