Dynamic Watefall chart

[Branagan_1]

Hi,

Is there a way of making the formatting of a graph so that the start and End bar are always the same colour format? I think this is probably VBA but a VBA trick but no sure?

The reason i need to do this is I am using dynamic waterfall chart (using a stacked graph) where the X axis changes size (with the number of products selected) and the formatting changes when I change the amount of products.

Any help would be amazing!

Thanks