Forum Discussion
Matthias93
Helper III
Helper IIIClustered column chart without X-axis values
Hi, 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...
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
v-qiuyu-msft
Community Support
Community SupportHi 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
Matthias93This worked perfectly for me, thank you very much