Is there a way to use several colours in a bar chart without manually setting the colours
I have a bar chart where I would like the bars to be different colours instead of all the same colour. Setting by value wouldn't be appropriate and I don't want to assign individual colours as there could be dozens of different X values. I'd be happy if it could use a set of default colours like it does for a pie chart and it cycles round once it's used all the colours. I don't much care what colour each bar is, I just want them to be different from their immediate neighbours.