Create a Stock Price Slider Chart in Excel | Everyday Office

Indicating where the Current Price falls between the Low 52-wk Price and the High 52-wk Price could be done in a number of ways. In this video, we replicate a chart requested on / excel with a Stacked Bar chart and a little extra math.
Everyday Office is the media arm of Knack Training, a software and professional development training and consulting company headquartered in Orlando, FL. More content can be found on:
- www.knacktraini...
- www.knacktraini...
Check the playlists on the Everyday Office channel for more tutorials in the areas you are having the most trouble with.

[@ArnoldasEkleris]

Thank you for this, mate! This will make my tracker more representative!

[@pedrocotta8320]

Excellent presentation. Thanks.

[@lostpulsar]

Hey buddy, you made my day!! There's any way to do the same on google sheet? One more, if the price change is the chart messing up? Tnx

[@MC-mb7fz]

Late to the party but I did sub. I have a Q: If I am using this for my watch list sheet of 40 odd stocks how do I create this from the table with uniform sized columns? When I follow your guide but select a table not a single stock the bar graph works and the marker but the rows are all over the place one long, next one tiny? I need them to scale uniform. Any advice appreciated.

[@LuniLadi]

I LOVE this video. It was exactly what I needed to include in my portfolio spreadsheet. I'm a new Excel 365 user. I watched your video, made 2-3 sliders ...everything was fine. Came back to finish and I can't seem to format the labels. If I'm ONLINE I have all the data but don't have the option to "use value from cells". Can't right click the chart and get that. If I'm using Excel on my LAPTOP offline I do have that option but the whole chart/label is blank cause I'm missing the data (just have a bunch of cell with #NAME? in them) Could you please help/explain what's going on? Thanks so much for your help and a great tutorial

[@ShephaliKhalkho]

What to do when current price and low price are same? and when its doji candle (all prices being same)?

[@julianizdebski5035]

When I go to full value (100% to the right) it makes the maker ~40% the size of the slider, any idea? besides that great. (works fine on the left/lower end - just broken on right/high end)

[@bperez8656]

Can I hire you for 1 on 1 consultations?

[@snterp]

That was weird. Why would you call it a slider if it doesn't slide?

[@KnackTraining]

It slides as the values change - not as a clickable item by the user. It was the best I could come up with - feel free to give me a new name for it!