Forum Discussion
Solved
Clustered 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
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
This worked perfectly for me, thank you very much