Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-19-2015, 07:51 AM
jgallet jgallet is offline Create a Bar with a slider that move based on data Windows 8 Create a Bar with a slider that move based on data Office 2013
Novice
Create a Bar with a slider that move based on data
 
Join Date: Aug 2015
Posts: 6
jgallet is on a distinguished road
Default Create a Bar with a slider that move based on data

Hello,

I am wondering if there is any possibility to create a Bar with a slider that will move to the left, center or right based on data. For example, if a number gets to 60 the slider will move to the right (green) vs if the number gets to 20 the slider will move to the left (red), center will be 50. See pictures. Appreciate your help!!!!
Attached Files
File Type: xlsx Dashboard.xlsx (22.5 KB, 7 views)
Reply With Quote
  #2  
Old 08-19-2015, 10:05 AM
jgallet jgallet is offline Create a Bar with a slider that move based on data Windows 8 Create a Bar with a slider that move based on data Office 2013
Novice
Create a Bar with a slider that move based on data
 
Join Date: Aug 2015
Posts: 6
jgallet is on a distinguished road
Default

For some reason the message was deleted. I am wodering if I can do a slider that moves based on the data input. For example (see attachment), If something falls within a specific rage, the slider will move to the right, left or will be kept in the center. So, is there any way to do this automatically when you change the data?
Reply With Quote
  #3  
Old 08-19-2015, 10:48 AM
gebobs gebobs is offline Create a Bar with a slider that move based on data Windows 7 64bit Create a Bar with a slider that move based on data Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Use a bar graph
Reply With Quote
  #4  
Old 08-19-2015, 01:58 PM
jgallet jgallet is offline Create a Bar with a slider that move based on data Windows 8 Create a Bar with a slider that move based on data Office 2013
Novice
Create a Bar with a slider that move based on data
 
Join Date: Aug 2015
Posts: 6
jgallet is on a distinguished road
Default

any better option than a bar graph? I wont be able to handle the info thru a bar graph...
Reply With Quote
  #5  
Old 08-19-2015, 03:19 PM
gebobs gebobs is offline Create a Bar with a slider that move based on data Windows 7 64bit Create a Bar with a slider that move based on data Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Are you trying to change the data with the slider?
Reply With Quote
  #6  
Old 08-20-2015, 05:41 AM
jgallet jgallet is offline Create a Bar with a slider that move based on data Windows 8 Create a Bar with a slider that move based on data Office 2013
Novice
Create a Bar with a slider that move based on data
 
Join Date: Aug 2015
Posts: 6
jgallet is on a distinguished road
Default

Not, I am trying to change the slider with the data...
Reply With Quote
  #7  
Old 08-20-2015, 06:23 AM
gebobs gebobs is offline Create a Bar with a slider that move based on data Windows 7 64bit Create a Bar with a slider that move based on data Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

In that case, I don't understand what you mean by "I wont be able to handle the info thru a bar graph."
Reply With Quote
  #8  
Old 08-21-2015, 10:21 AM
jgallet jgallet is offline Create a Bar with a slider that move based on data Windows 8 Create a Bar with a slider that move based on data Office 2013
Novice
Create a Bar with a slider that move based on data
 
Join Date: Aug 2015
Posts: 6
jgallet is on a distinguished road
Default

hello do you see the attachment? I have more than 50 KPIs, how can I use a graph bar and allocate each bar next to the KPI, similar to the attachment. Appreciate..
Reply With Quote
  #9  
Old 08-21-2015, 03:41 PM
Guloluseus Guloluseus is offline Create a Bar with a slider that move based on data Windows 7 64bit Create a Bar with a slider that move based on data Office 2010 32bit
Competent Performer
 
Join Date: Mar 2013
Posts: 168
Guloluseus is on a distinguished road
Default

I would suggest that you check your attachments; for me at least, theres nothing there.

Also I suggest looking at what you have written before posting, your last comment could be taken in a way that would lead some to decide they do not wish to be active in this thread, as it could come across as somewhat sarcastic. I guess its not meant that way, as that would be rude.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to create a data validation based on another cell's value?? cfreezy Excel 1 06-18-2015 09:51 AM
Retrieving data from data base based on text selection capitala PowerPoint 0 12-10-2014 08:10 AM
Create a Bar with a slider that move based on data Can't grab hanging indent slider because of a tab stop in exact same spot WaltR Word 2 10-28-2014 09:56 AM
Why page slider not with 2 pages on screen? Alpina Word 1 04-13-2013 12:01 AM
Create index based on bullet numbers EZRider Word 0 07-10-2009 09:21 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:24 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft