Hi all,
I have tried searching for the solution to my query, but to no avail.
I am creating a chart where I want (actually my boss wants) the columns of different colours, but the titles on the x-axis underneath to correspond with the colour. i.e.
R 15% Column in Red
A 25% Column in Amber
G 45% Column in Green
NA 20% Column in Grey
If I set the chart as Series in Rows I can get the titles, and if I set the Series in Columns I can change the bar colours. However, I don't seem to be able to have both.
Any hints short of manually adding the titles via text boxes would be very much appreciated.
Chris
I have tried searching for the solution to my query, but to no avail.
I am creating a chart where I want (actually my boss wants) the columns of different colours, but the titles on the x-axis underneath to correspond with the colour. i.e.
R 15% Column in Red
A 25% Column in Amber
G 45% Column in Green
NA 20% Column in Grey
If I set the chart as Series in Rows I can get the titles, and if I set the Series in Columns I can change the bar colours. However, I don't seem to be able to have both.
Any hints short of manually adding the titles via text boxes would be very much appreciated.
Chris