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.
There is a small issue with the slider. When you calculate the size of the Marker, if you calculate it using the size of the Base, then the Marker will change size. Instead, If you make the Marker based on the difference between the high and low, those numbers are fixed and therefore the size of the marker will stay the same. The rest of the formula more or less works after that.
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)
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
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.
There is a small issue with the slider. When you calculate the size of the Marker, if you calculate it using the size of the Base, then the Marker will change size. Instead, If you make the Marker based on the difference between the high and low, those numbers are fixed and therefore the size of the marker will stay the same. The rest of the formula more or less works after that.
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)
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)?
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!