How to get another field into a clustered bar chart?

[Kempzo]

Hi!

I have a clustered bar chart as below: currently it shows the payment terms grouped together and then the amount of suppliers which have these payment terms.

I would like to have the different bars split into classifications is this possible?

I.e. so half would show Local supplier and the other half would say preferred supplier etc. To do this I need to get the SupplierRef_Classification – Name field somehow into the bar chart?

[v-zhangti]

Hi, @Kempzo 

I have simulated some data that I hope fits your situation.

Initial chart:

Result:

Is this the result you expect? If not, please provide more information.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Kempzo]

Hi!

Thanks for your time, yes it is almost that but I was wondering if it could just be the single bar split into the different categories? Rather than having the 2 different bars for each category

As below

Thanks!

[Syk]

You just need to change your chart from a clustered column chart to a stacked column chart!