How do I display both x axis labels on a bar chart ?

[#1]

Hi,

I have a bar chart which is summing a value against two dimensions (region and year). The graph displays a vertical column for each year for each region.

I can show the legend for the 'Region' dimension, but not for the 'Year'. I've checked the 'Show legend' checkbox for both dimensions but only the region values are displayed on the chart.

is there anyone who can help me with this please.

Thanks

Mo

[hic · Accepted solution]

The legend for the second dimension will be showed to the right in the graph.

HIC

[nizamsha]

use Region as first dimension and year as second dimension

So  Region will sit in horizontal position  and year will sit in vertical  position .use one expression so each dimension eg region as South .for south u will see two bars

u will see the two bar one for current year and  another one for last year