Sliders in a dashboard

[comonand]

Hi folks,

Im trying to pretty up a dashboard, there are 3 boxes a user can enter %'s into that generate a table of cost.

So i have cost for DayTime cover NightTime cover and Weekend cover they need to add up to 100% of the time. That generates the table of best options.

This works fine, i have a conditional format if the 3 numbers do not equal 100% (it has to)

Is there a way of doing it with a slider or other object im not aware of, i envision something like a slider but with 3 things that slide.

3 Seperate sliders you still have the problem that they need to add up to 100. Unless they dynamically changed somehow.

I'm not tied to sliders, its the only thing i could think of. I would prefer not to use VBA, i'd just leave as is if thats the only option.

Thanks,

 

[comonand]

Just to give a better idea of what i am trying to do.

Something like this, but it uses a freeze pane to get rid of the inside ends of the sliders, so isnt visually clean enough, also can only go to 50% max for the day or weekend %