Hi Jon,

I tried the method as you suggested and it works successfully. Thank
you very much for your help.


Also is it possible to add in a vertical line per every single 'x'
variable candle so that I am able to see each day clearly. For e.g. I
want to have a vertical line down the graph every 12 candles in the
candle chart graph.

I have seen this done in another chart excel file I have however I do
not know how to add this function as the excel file has been locked
and password protected.


Cheers,

Chris