Forum Discussion
Clustered column chart - gaps in data
Hi there
I am hoping someone can help with an issue I have. I have data similar to that shown below. 1 indictaes they attended the course, a zero that they didn't. I want a column chart with the height of the bar representing the number of attendees for each course.
When I create a clustered column chart I end up with a huge gap on the left and right as shown and I cannot get rid of it.
I have added the fields to the y axis as shown but not made any other changes
I have tried filtering, adjusting the formatting, moving the fields into other places but no option removes the huge gaps. Has anyone got any advice? At the moment my solution would be to use a pie chart instead but I really wanted the data in a column chart.
TIA
Lara
Hi LaraMellor ,
Here are the steps you can follow：
1. Power Query -- Select the following four columns -- Unpivot Columns .
Result：
2. Result:
[Attribute] is placed in X-axis
[Value] is placed in Y-axis
Is this way acceptable to you
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
4 Replies
I hadn't but I've just tried it and that makes no difference unfortunately.
Hi LaraMellor ,
Here are the steps you can follow：
1. Power Query -- Select the following four columns -- Unpivot Columns .
Result：
2. Result:
[Attribute] is placed in X-axis
[Value] is placed in Y-axis
Is this way acceptable to you
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
That is perfect. Thank you so much for your help
