Display Series Names Along Horizontal Axis

[SecularHaze]

I am using the following code to add data from different sheets to a chart:

Please Login or Register  to view this content.

Now this works, producing the following result:

Capture.PNG

Unfortunately, this displays the category name on the horizontal axis. Is there a way, by either changing/adding to the code or by just reformatting the chart object itself, that I can have it automatically display the series name below each bar as they're added and removed?
Any help is much appreciated.

[Andy Pope]

You can not display series names on the category axis.

it's Series names in the legend
Category names on the category axis

You can either change the data layout, as well as the category text.

Or use category labels only, with the Vary fill colour by point.