Clustered bar chart, two categories, two measures. Goal: two different colour for each category.

[ab00]

I have the following data

Cost per Product current month.

Cost per product prevous month.

Axis: Product Name (Four Products, Product A to D)

Right now I'm showing a clustered bar chart, with the values for each product, showing the costs per product for the current and prevous month.

My goal is to assign each column respectively each product two different colours that will show the two measures I have.

Right now, it is looking like this:

Unfortunately, it is not possible to move the Product Name (Produkt Name) from axis to legend.

How can I get the two colours with the category field?

[Icey]

Hi @ab00 ,

I create a simple example. How about this?

Best Regards,

Icey

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

[ab00]

Hello, 

That's exactly what I'm looking for. Unfortunatly it doesn't work, when using two different values per category.

[FlavioMeneses]

Just use a stacked bar chart instead.

[ab00]

Thanks for the suggestion. The problem is that, in my opinion, the stacked bar chart is not as suitable to show the comparison between the values of the current month and the previous month as the clustered bar chart is.

[Fowmy]

@ab00 

You cannot use a value on the Legend on Clustered Bar Chart as you desire. Can you provide more details as to what you are trying to achieve?

[ab00]

My goal is to use different colors for each product. Right now I have two gray colors, one for the values of the current month and one for the values of the previous month, because in the image the two colors are the same for each product. I would like to customize the colors to be able to use, for example, two different green colors for product A, two different blue colors for product B and so on.