+ Reply to Thread
Results 1 to 4 of 4

Visual Bar to show Last Price between High and Low

  1. #1
    Registered User
    Join Date
    04-27-2020
    Location
    India
    MS-Off Ver
    2016
    Posts
    6

    Visual Bar to show Last Price between High and Low

    Hi,

    I have a table with Open, High, Low and Last Price. I want a bar on my dashboard which visually shows a line color bar between High & Low values and a marker on the Last Price that would be a point between High & Low.

    Please help


    Rgds,
    Dhruv
    Attached Files Attached Files

  2. #2
    Forum Expert ben_hensel's Avatar
    Join Date
    01-26-2012
    Location
    Rocester, New York, USA
    MS-Off Ver
    Excel 2007:10
    Posts
    1,966

    Re: Visual Bar to show Last Price between High and Low

    Add a column for "spread", which =High - Low

    Then a combo chart that is
    1) Stacked Columns for Low and Spread (turn off the fill for the Low Column)
    2) Line chart for the Last Price
    Attached Files Attached Files
    Click the [* Add Reputation] Button to thank people for help!
    Post Attachment: Click [Go Advanced] under the reply box; then click [Manage Attachments] to launch the attachments dialogue.
    Mark Thread Solved: Go to the top of the first post; Select [Thread Tools] dropdown; Pick the [Mark thread as Solved] option.

  3. #3
    Registered User
    Join Date
    04-27-2020
    Location
    India
    MS-Off Ver
    2016
    Posts
    6

    Re: Visual Bar to show Last Price between High and Low

    Hi,

    Thanks for your attempt but this is not what I want. I want something like shows in attached picture if possible.

    A bar on worksheet itself (not on a separate chart) starting from High to Low and changing colour or some kind of a market at the Last Traded Price (which would be between high and low)

    Thanks


    Dhruv
    Attached Images Attached Images

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    9,564

    Re: Visual Bar to show Last Price between High and Low

    Excel's sparklines are the closest thing I can think of.
    On Sheet2 the order of the data is changed so that the last price will be the middle marker (blue) on the sparkline.
    High marker is green and low marker is red. Markers may be changed using the utilizing the sparkline tools design tab.
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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