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

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

Hi,

Thanks for your reply. Sparkline is good when I am working on trends. Here I am looking more for a bar to show a line between high & low points with marking or shading of the last traded price which would be a point between high and low.

Rgds,
Dhruv