Forum Discussion
Clustered bar chart, two categories, two measures. Goal: two different colour for each category.
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?
6 Replies
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.
- FlavioMeneses
Advocate II
Just use a stacked bar chart instead.
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.
Hello,
That's exactly what I'm looking for. Unfortunatly it doesn't work, when using two different values per category.
