Adding a straight line current price indicator in VOHLC Chart?

  • Hi!

    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?

    Regards,

    Naira


    PS: Question also posted at http://www.excelforum.com/exce…cator-in-vohlc-chart.html

  • Re: Adding a straight line current price indicator in VOHLC Chart?


    I know its not pretty, but you could make Column F Current Price. If you only want one input filed, have Column F = to that input filed.
    Add column F to your Chart (select the chart, go to Design, click on Selet Data, add column F)
    Once added to the Chart you can change the type for that data set by right clicking on one of the data points on the chart and go to Format Data Series. Go to Line Color, Select Solid, or whatever line type you want.


    as far as adding text to it, im not sure

  • Re: Adding a straight line current price indicator in VOHLC Chart?


    hi Goin,


    Had already tried that but it doesn't work.
    Can you please try it and attach the new file?
    thanx

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!