1. I was wondering whether it is possible to add one or more straight lines (perhaps a new series?), indicating the current price (or other price levels) to a VOHLC Chart in excel. (As the red line in the sample file attached).
The value will be the current price of the Instrument and will be carried in a single cell and the cell value changes dynamically.
2. Also, is it possible to show/ add some name to this indicator line that can be shown in the middle of the chart or on the side as an index value that moves up and down with the indicator line (P in the sample file attached) (This is optional feature request).
I read somewhere that it is possible to do so with a scatter chart etc. and then change it to a line, but when I try it, I get an error saying that some chart types cannot be mixed with other. I am using both excel 2007 and Excel 2010 but get errors in both.
Could someone please tell me the procedure step wise and show it in the Sample file is attached?
PS: Question also posted at http://www.excelforum.com/exce…cator-in-vohlc-chart.html