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,
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
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
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.
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
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.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks