Changing colour of bar chart, whilst keeping the labels on x-axis

[trueng]

To change the colour of bar charts, I split the data series into 3.

This works, however, in Catagory (X) axis labels only shows one of the labels.



The labels works fine when there is only 1 series of data.
But when there are 3 series of data, only one label remains, despite attempts in changing the Catogory (X) axis label manually on each series.

Anyone knows how to fix this problem?


Thank you in advance.

[Melvinrobb]

You were editing the Axis TITLE, not the Data labels.
Would the attached work?

[Andy Pope]

Either,
Format series and on the Fill tab set 'Vary colors by point'.

Or change data layout so you have 3 series instead of 1 and set Overlap to 100%

[trueng]

Sort of. I was hoping retain the original format which is where the labels are on the axis.

On the solution file, I think you've just removed any labels on the axis, and put the legend at the bottom.

[trueng]

This works!! Thank you.

[trueng]

Did not get it to work when I set the Overlap to 100%.

The largest bar ends up overlapping the other two.

Nevertheless, the first method works.

[Andy Pope]

Did you change the data layout when using the overlap approach?