Page 1
Page 1
Started By
Message
locked post

Excel - How to add control bar with multiple stops???

Posted on 3/17/22 at 3:29 pm
Posted by SlapahoeTribe
Tiger Nation
Member since Jul 2012
12451 posts
Posted on 3/17/22 at 3:29 pm
Anyone happen to know how to add a scroll bar that will select data, but has multiple stops? Something like the gradient bar in the fill options…



I have several lists of values that I need to be able to sum into different groups and need to be able to adjust those groupings to determine the best fit for each day.


ETA - Thought I had selected the tech board before I started the topic. Please move.

For your troubles…


This post was edited on 3/17/22 at 3:43 pm
Posted by Winston Cup
Dallas Cowboys Fan
Member since May 2016
66742 posts
Posted on 3/17/22 at 3:36 pm to
the tournament is on bozo why are you still working
Posted by GetCocky11
Calgary, AB
Member since Oct 2012
53509 posts
Posted on 3/17/22 at 3:40 pm to
quote:

the tournament is on bozo why are you still working




I honestly thought the white collar world shut down during these 2 days.
Posted by IMAb4u
Member since Mar 2022
23 posts
Posted on 3/17/22 at 3:42 pm to
quote:

the tournament is on bozo why are you still working
Posted by WildManGoose
Member since Nov 2005
4600 posts
Posted on 3/17/22 at 3:43 pm to
quote:

I have several lists of values that I need to be able to sum into different groups and need to be able to adjust those groupings to determine the best fit for each day.
You can't use power pivot for that?
Posted by SlapahoeTribe
Tiger Nation
Member since Jul 2012
12451 posts
Posted on 3/17/22 at 3:48 pm to
quote:

You can't use power pivot for that?

Unless there’s some feature I’m missing, I’m not sure that’ll work. I’m hoping to have a visual slider that I can drag to see how different selections will give different sums.
Posted by caliegeaux
Member since Aug 2004
12441 posts
Posted on 3/17/22 at 3:51 pm to
pics 1 and 3 just added a scroll bar in my tightie whities.
Posted by WildManGoose
Member since Nov 2005
4600 posts
Posted on 3/17/22 at 4:03 pm to
quote:

Unless there’s some feature I’m missing, I’m not sure that’ll work. I’m hoping to have a visual slider that I can drag to see how different selections will give different sums.
You can add a slicer to sort by an independent variable. If you do it in PowerBI you can make it look like a slider.
Posted by soccerfüt
Location: A Series of Tubes
Member since May 2013
72924 posts
Posted on 3/17/22 at 4:04 pm to
Simple as 1,2,3
Posted by momentoftruth87
Your mom
Member since Oct 2013
86110 posts
Posted on 3/17/22 at 4:09 pm to
You’ll find better results looking on Google or YouTube.

Google.com
- “How to add control bar with multiple stops in Excel”

Posted by greenbean
USAF Retired - 31 years
Member since Feb 2019
6111 posts
Posted on 3/17/22 at 4:11 pm to
that's woman's work, what next you gonna make sammies and fetch coffee for the boss mane?
first pageprev pagePage 1 of 1Next pagelast page
refresh

Back to top
logoFollow TigerDroppings for LSU Football News
Follow us on X, Facebook and Instagram to get the latest updates on LSU Football and Recruiting.

FacebookXInstagram