Thread: Bar Chart Updates From Left To Right

Hello
The chart as it receives new information is updating with the newest bar appearing on the left hand side. It's driving me nuts. How do I change it so it updates from the right please
Thanks
Excel 2010

It's alright don't panic, I've found it in the ribbon
In the Axes button. I'd deleted the axis as it was in the way. I realised afterwards, the chart was updating back to front, because the formula updates at the top of the chart data column. It's a small chart