multiple time horizon

Hi,

I have attached a chart, in which I would like to see the data series in red to be placed at its right place i.e. attached to the secondary axis instead of the primary one. It is self explanatory once looking at the chart but I just cannot move it where it belongs too. Btw. I asked a friend who programs for a hedge fund (some algorithm trading bunch) and he suggested that I use two separate charts for the two series...

Any suggestion would be highly appreciated.

Cheers,

David

Originally Posted by Andy Pope

First problem is your dates are not all dates.
Change the number format to general and all those that are displayed as dates are really text.

Once you convert you values to dates you can move the line to the secondary value axis.
You will also need to add a secondary x axis and set the scale to match primary x axis

Thanks very much Andy, I did all that but it is not going anywhere, I have attached it again with the proper format for the dates... just in case you'd like to have a look at it. Cheers, David