Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-20-2015, 05:41 PM
Liz T Liz T is offline Need help developing a way to visually represent information on Word Windows XP Need help developing a way to visually represent information on Word Office 2010 32bit
Novice
Need help developing a way to visually represent information on Word
 
Join Date: Jul 2015
Posts: 2
Liz T is on a distinguished road
Default Need help developing a way to visually represent information on Word


Hi all,

The attached document is a capability framework that measures employee's skill levels. On this form I want to show where the employee is on the framework when they are hired; where they are on the framework when they are performance assessed and; where their target capability level should be.

The issue however is that within the five levels an employee might be at the upper end of the level and almost ready to progress to the next (or only just reached the beginning of a level) - therefore it's not as simple as putting an 'x' in the correct box.

Could you please help me think of an effective and user friendly way to represent the data visually on Word?

Thanks!
Liz
Attached Files
File Type: docx PSC Framework.docx (14.9 KB, 18 views)
Reply With Quote
  #2  
Old 07-22-2015, 01:43 PM
Pytheus Pytheus is offline Need help developing a way to visually represent information on Word Windows 8 Need help developing a way to visually represent information on Word Office 2013
Novice
 
Join Date: Jul 2015
Posts: 3
Pytheus is on a distinguished road
Default

Sorry its got me a bit stumped..

It's outside my skillset, but maybe someone could develop a VBA control assigned to a scroll bar. Then the colours can move based on where the scrollbar is positioned?

Sounds complicated to develop though and not sure it would work within a table though.

Maybe the alternative is to place a number box where the user can place a rating? Again to visually represent it would require some VBA, so you might need to post or move this post to that forum? (the VBA geniuses probably dont come in here much)
Reply With Quote
  #3  
Old 07-22-2015, 04:16 PM
Liz T Liz T is offline Need help developing a way to visually represent information on Word Windows XP Need help developing a way to visually represent information on Word Office 2010 32bit
Novice
Need help developing a way to visually represent information on Word
 
Join Date: Jul 2015
Posts: 2
Liz T is on a distinguished road
Default

Thanks for your reply in any case!
Reply With Quote
  #4  
Old 07-22-2015, 08:37 PM
Charles Kenyon Charles Kenyon is offline Need help developing a way to visually represent information on Word Windows 8 Need help developing a way to visually represent information on Word Office 2013
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,464
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Excel charts might be a better tool for this.
Reply With Quote
  #5  
Old 07-22-2015, 09:10 PM
macropod's Avatar
macropod macropod is offline Need help developing a way to visually represent information on Word Windows 7 64bit Need help developing a way to visually represent information on Word Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,369
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

There are numerous ways you could handle this.

Perhaps the simplest approach is to insert a horizontal line, drawn from the left and extending as far right as needed to depict the progress. A more complicated approach would be to change the font format of the cells concerned to Courier New. Coupled with setting the line spacing to single and the cell margins to 0, you could fill each cell with up to 10 block characters created by typing 2588, Alt-x. With this approach, though, you can even colour the individual characters differently.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Need help developing a way to visually represent information on Word Extracting information from Image in word Flambo Word 2 05-06-2012 10:43 PM
Need help developing a way to visually represent information on Word Developing a dynamic power point presentation mgoldberg PowerPoint 1 04-03-2012 05:48 AM
Need help developing a way to visually represent information on Word Can Tables or Information be Linked in Word? ddrowe Word 1 11-18-2011 11:50 AM
Need help developing a way to visually represent information on Word Word Information page rbekel Word 2 04-18-2011 07:01 PM
Printing Some Calendar Appointment Information for Visually Impared. Palmettokid Outlook 2 04-08-2009 08:39 AM

Other Forums: Access Forums

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


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