Create a Stock Price Slider Chart in Excel | Everyday Office
HTML-код
- Опубликовано: 11 сен 2024
- 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.
Thank you for this, mate! This will make my tracker more representative!
Excellent presentation. Thanks.
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
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.
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
What to do when current price and low price are same? and when its doji candle (all prices being same)?
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)
Can I hire you for 1 on 1 consultations?
That was weird. Why would you call it a slider if it doesn't slide?
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!