Thanks again. I am unable to use different series for each data.

To draw each colour as a different series, each of the series is given a space on the chart even if its not been set, this means the chart ends up with too many spaces where there is no values.
e.g 10 series will show space on the chart for each of the ten series when I only want to draw the "bar" for which has a value.

Perhaps I don't understand how to use series data in a bar chart? Am I able to get contiguous data shown on the chart?

I attach an example chart with the sort of results I would like.

The actual chart will show up to 5,000 bars at a time.

As for the actual requirement, the best way to replicate my data is to randomly generate values between 0 and 500. Then dislplay those values in a bar chart, one after another, using different colours for values 0-50, 51-100, 101-200,201-500.

Thankls again.