Hi,

Is there a way to force Excel to keep a consistent format for charts. I have a clustered bar chart that has three bars that I am after. With the data that I have, if there is three or more batches, then the chart comes out correctly with the three columns (see Correct image) if there is less than 3, excel swaps the Y axis for the series data (see incorrect image) which is now out of my jurisdiction as it is all generated from an excel VBA script, not done manually.

What do I need to add to get these bits correct.

Kind regards

Rob

Correct.PNGIncorrect.PNG