You can use the combination of major gridlines (use light gray instead of
the default black!), and changing the X axis scale so the Y axis does not
cross between categories. Though keeping the Y axis crossing between
categories will put a line between each candlestick, which may also work.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


wrote in message
...
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