Clustered column chart without X-axis values

[Matthias93]

DataGraphHi,

I'm trying to make a clustered colum chart, but I have no values on my x-axis. This makes that the bars of my chart are really close to each other and make for an ugly visual. My data is built up as follows: Answer 1 (Value) Answer 2 (Value)... The value ranges between 1 and 5 in whole numbers. On the x-axis I would like to have the different answers or questions and on the y-axis the average values per answer. Can somebody help me do this?

Thanks in advance,

Kind regards,

Matt

[v-qiuyu-msft · Accepted solution]

Hi @Matthias93,

According to your description, you want to display different answers on X-axis, and show average value for each answer, right?

In your scenario, you can open Query Editor and select columns from Answer 1 to Answer 8, then click Unpivot Columns under Transform tab. See:

Best Regards,
Qiuyun Yu

[Matthias93]

This worked perfectly for me, thank you very much

[Greg_Deckler]

You can add Text columns as x-axis values. Or, you might add an Index to your import?