+ Reply to Thread
Results 1 to 1 of 1

Adding a straight line current price indicator in VOHLC Chart?

  1. #1
    Registered User
    Join Date
    MS-Off Ver
    Pro Plus 2019

    Unhappy Adding a straight line current price indicator in VOHLC Chart?


    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?


    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1