stack bar chart two dimensions labels on x-axis

[Anonymous]

Hi all,

I have a stack bar chart with two dimensions. Right now the labels on the x-axis are concatenated e.g. apples-2015, apples-2016, apples-2017, orange-2015, orange-2016, orange, 2017,etc.

The reason being is because I concatenated these two fields (fruit and year) to produce a stacked bar chart with two dimensions.

Is there any way to clean the labels on the x-axis so they look this (see the Excel graph I want to replicate)

[ogautier62]

Hi

what does mean the third dimension <1year, +1 year

how is it calculated ?

regards

[Anonymous]

I have attached sample data in the original post. Its the sum found in the 'number' field over the total

[balabhaskarqlik]

Is there any way to clean the labels on the x-axis so they look this...

May be you can only show the title of the dimensions without values...

[Anonymous]

Each stack represents a year and a product. It would be essential to have both