Cluster Column Chart for column type data

[yashgoyal]

Please help how to generate Cluster Column Chart for column type data on this type of data

GL Dept	Current JAN	Current Feb	Current Mar	Current Apr
152955	4	4	4	4
153365	57	57	57	57
153365	0	0	0	0
153520	1	1	1	1

[yashgoyal]

Thanks Pat

[mahoneypat · Accepted solution]

You need to unpivot your data in the query editor. Select your GL Dept column, right click and choose "unpivot other columns". You will then have a three-column table including two new columns called attribute and value. You can rename those to month and whatever your values are, and then make your chart using the Month column as the legend.

Pat