Create a Stock Price Slider Chart in Excel

No video

Create a Stock Price Slider Chart in Excel | Everyday Office

Рет қаралды 7,045

Күн бұрын

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.

Пікірлер: 10

@ArnoldasEkleris 4 жыл бұрын

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

@lostpulsar 2 жыл бұрын

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

@pedrocotta8320 Жыл бұрын

Excellent presentation. Thanks.

@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 2 жыл бұрын

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)