Voyage Tech Blogs

Voyage Technology has been serving the Beaver Dam area since 1999, providing IT Support such as technical helpdesk support, computer support, and consulting to small and medium-sized businesses.

Tip of the Week: Use People Graphs in Excel for Data Visualization

Tip of the Week: Use People Graphs in Excel for Data Visualization

With Microsoft Excel, you can use visuals to represent your data, providing greater context for the contents of your spreadsheets and making it easier to communicate what it all means. This week’s tip focuses on People Graphs, a feature that can be powerful when used appropriately.

Explaining People Graphs

One of the Microsoft Office Add-Ins your organization can use is the option to use People Graphs for data visualization. The default icon is a person, but you can also customize it with various icons like stars, hearts, clocks, bags of money, or otherwise.

Here’s how you can make a People Graph using a simple set of data.

How to Create a People Graph

The first thing you need to make a People Graph is the spreadsheet from which it will pull its data. For example, let's say you wanted to share some statistics about the work/life balance of today’s workforce. You might list out the statistics in one column, then include the actual numeric values for those statistics in another column.

Once you have your spreadsheet ready to go, select the data range. Then, using the Insert toolbar, find the option for People Graph. It will be located in Add-Ins. You’ll see a premade graph populate on the sheet. You can then use the Settings option from the top-right corner of the graph to make any adjustments you need to it.

You have a fair amount of control over how the graph looks, including its color scheme and the shape of the icons.

After you’ve customized it to your liking, you can select the grid button next to the Settings. You can use this to customize the title of your graph or the data that it pulls its information from.

Once you have selected the data, all you have to do is click on Create. This will complete your People Graph.

Did you find this helpful? We’re full of neat tips and tricks, so be sure to keep an eye on our blog for more.

 

Comments

No comments made yet. Be the first to submit a comment
Already Registered? Login Here
Guest
Tuesday, 18 February 2025

Captcha Image

Sign Up For Our Newsletter!

Mobile? Grab this Article!

Qr Code

Tag Cloud

Security Technology Tip of the Week Best Practices Business Computing Data Productivity Business Software Innovation Hackers Cloud Network Security User Tips Hardware Internet Efficiency IT Support Malware Privacy Email Google Phishing Workplace Tips Computer Collaboration IT Services Users Hosted Solutions Mobile Device Quick Tips Ransomware Small Business Cybersecurity Microsoft Workplace Strategy Communication Data Backup Smartphone Passwords Saving Money Business Management VoIP Smartphones Android Mobile Devices communications Backup Data Recovery Managed Service Upgrade Browser Managed IT Services Disaster Recovery Social Media Microsoft Office Tech Term Network Internet of Things Remote Windows Facebook Automation Artificial Intelligence Cloud Computing Covid-19 Miscellaneous Current Events Gadgets Productivity Remote Work Server Managed Service Provider Outsourced IT Information Holiday Encryption Spam AI Employee/Employer Relationship Windows 10 Business Continuity Compliance Government Office Training Data Management Virtualization Blockchain Wi-Fi Business Technology Windows 10 Bandwidth Data Security Apps Two-factor Authentication Mobile Office Apple Networking App Employer-Employee Relationship Vendor Mobile Device Management Chrome Gmail Managed Services Voice over Internet Protocol Budget WiFi How To BDR BYOD Computing Hacker Applications Information Technology Avoiding Downtime Marketing Access Control Office 365 Tip of the week Conferencing Storage Password Healthcare Bring Your Own Device Managed IT Services Big Data Operating System HIPAA Computers Router Virtual Private Network Risk Management Website Health Help Desk Analytics Office Tips Augmented Reality Retail Telephone The Internet of Things Scam Data loss Social Cooperation Free Resource Project Management Windows 7 Going Green Patch Management Save Money Microsoft 365 Remote Monitoring End of Support Vulnerability Vendor Management Solutions Customer Service Cybercrime Display Printer Windows 11 Paperless Office Infrastructure Monitoring 2FA IT Support Excel Firewall Document Management Remote Workers Safety Maintenance Antivirus Sports Downloads iPhone Mouse Licensing Administration Vulnerabilities Entertainment Data Privacy Images 101 Robot Mobility Telephone System Multi-Factor Authentication Cost Management Customer Relationship Management Settings Wireless Printing Content Filtering Hacking IT Management Presentation VPN Employees YouTube Meetings Physical Security Integration Cryptocurrency Wireless Technology User Tip Modem Computer Repair Mobile Security Processor Virtual Desktop Holidays LiFi Data storage Data Storage Smart Technology Supply Chain Word Video Conferencing Outlook Machine Learning Managed Services Provider Professional Services Money Saving Time Virtual Machines Humor Managed IT Service Deep Learning Download Net Neutrality Twitter Alerts SQL Server Technology Care Undo Financial Data Error History Business Communications Education Connectivity IT Social Engineering Break Fix Scams Browsers Smartwatch Upload Procurement Remote Computing Azure Hybrid Work Multi-Factor Security Tech Human Resources Mobile Computing Social Network Telework Cyber security Tablet IoT Communitications Search Dark Web Cables CES Application Best Practice Trends Supply Chain Management Alert Dark Data Google Calendar Term Google Apps Managed IT Customer Resource management FinTech Buisness File Sharing Regulations IT solutions Star Wars IT Assessment How To Microsoft Excel IT Maintenance IBM Legal Data Analysis Business Growth Gamification Flexibility Notifications Staff Value Business Intelligence Legislation Shortcuts Organization Travel Social Networking Google Maps Smart Devices Cortana Ransmoware Techology Fileless Malware Digital Security Cameras Alt Codes Content Remote Working Wearable Technology Memory Vendors Comparison Google Play Be Proactive Competition Health IT Downtime Unified Threat Management Motherboard Data Breach Hosted Solution Assessment Electronic Health Records Permissions Workforce Unified Threat Management Directions Videos Typing Wasting Time Threats Network Congestion Specifications Security Cameras Workplace Strategies Trend Micro User Internet Exlporer Software as a Service Knowledge Fraud Meta Google Drive User Error Microchip Username Managing Costs Amazon 5G Black Friday SSID Point of Sale eCommerce Unified Communications Database Surveillance Experience Virtual Assistant Outsource IT IP Address Google Docs Bitcoin Network Management Running Cable Tech Support IT Technicians Virtual Machine Environment Media Monitors Cyber Monday Medical IT Google Wallet Proxy Server Reviews Cookies Recovery Tactics Development Hotspot Transportation Small Businesses Hard Drives Windows 8 Laptop Websites Mirgation Hypervisor Displays PowerPoint Domains Drones Shopping Nanotechnology Optimization Addiction Electronic Medical Records Language Employer/Employee Relationships Outsourcing SharePoint Refrigeration Management PCI DSS Halloween Chatbots Navigation Writing Distributed Denial of Service Workplace Public Speaking Lenovo Gig Economy Screen Reader Service Level Agreement Internet Service Provider Virtual Reality Computing Infrastructure Teamwork Hiring/Firing Lithium-ion battery Hacks Server Management Regulations Compliance Entrepreneur Scary Stories Private Cloud Identity Evernote Paperless Fun Co-managed IT Superfish Bookmark Identity Theft Smart Tech Memes

Blog Archive