Forum Discussion

michaelwtk's avatar
michaelwtk
Regular Visitor
8 years ago
Solved

Group Bar chart

  Given a dataset in the table below, can guide me how to create a group bar chart as shown above? Thanks I have tried, but once i drag the ColumnA and Column B inside the axis, the bar chart ...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi michaelwtk,

     

    You may need to unpivot original table structure in Query Editor mode.

     

     

    Then, insert a clustered column chart, add corresponding fields to chart as below:

     

    Best regards,

    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi michaelwtk,

 

You may need to unpivot original table structure in Query Editor mode.

 

 

Then, insert a clustered column chart, add corresponding fields to chart as below:

 

Best regards,

Yuliana Gu

stewarte18's avatar
stewarte18
Regular Visitor
6 years ago

I'm having a similar issue.  However, the data I'm trying to make into a bar chart cannot be combined into one column.  Below is how the chart looks now with an example of how I would like for it to look.  Any help is appreciated.