Clustered column chart - gaps in data

[LaraMellor]

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

[Anonymous · Accepted solution]

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

[LaraMellor]

That is perfect.  Thank you so much for your help

[DataInsights]

@LaraMellor,

Have you tried moving the legend? See the format setting below:

[LaraMellor]

I hadn't but I've just tried it and that makes no difference unfortunately.