Sliders in a dashboard

comonand

New Member
Joined
Feb 7, 2022
Messages
10
Office Version
  1. 365
Platform
  1. Windows
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,
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).
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 %

excel slider.png
 
Upvote 0

Forum statistics

Threads
1,213,489
Messages
6,113,953
Members
448,535
Latest member
alrossman

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top