Hi there,

I've been trying to create an OHLC chart from the data I've inputted into an excel spreadsheet. However, when i highlight the cells and click on the OHLC chart symbol, it always says - "To create this stock chart, arrange the data on your sheet in this order:...". The order is right i believe, and i've also made sure the cells and data are formatted to number (i think). I've also carried out tests on each cell to make sure, however I'm still getting the same error message. Can anyone help please?

Thanks.

ohlc problem.xlsx