Problem creating OHLC chart

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

Im not quite sure what you mean Martin. Ive added the labels like in the link you provided, but it still wont work. Ive attached the new workbook with labels to see what im trying to do...

Thanksohlc problem.xlsx

Thanks Martin, got it working! Much appreciated.