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
Friday, 28 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 Internet Hardware Efficiency IT Support Malware Privacy Email Phishing Google Workplace Tips Computer Users Collaboration IT Services Hosted Solutions Mobile Device Quick Tips Ransomware Cybersecurity Microsoft Workplace Strategy Small Business Data Backup Communication Passwords Smartphone Saving Money Android Business Management VoIP Smartphones Mobile Devices communications Backup Managed Service Upgrade Data Recovery Social Media Managed IT Services Browser Microsoft Office Disaster Recovery Windows Network Tech Term Remote Internet of Things Automation Artificial Intelligence Facebook Cloud Computing Covid-19 Productivity Remote Work Server Managed Service Provider Miscellaneous Current Events Gadgets Information Holiday Outsourced IT Encryption Spam AI Employee/Employer Relationship Windows 10 Government Office Training Data Management Business Continuity Compliance Blockchain Wi-Fi Business Technology Windows 10 Bandwidth Virtualization Apps Two-factor Authentication Mobile Office Data Security Employer-Employee Relationship Vendor Mobile Device Management Chrome Gmail Managed Services Voice over Internet Protocol Budget Apple Networking App BYOD Computing Hacker Applications Information Technology Avoiding Downtime Marketing Access Control Office 365 Tip of the week Conferencing WiFi How To BDR Operating System HIPAA Computers Router Virtual Private Network Risk Management Website Health Help Desk Analytics Office Tips Augmented Reality Retail Storage Password Healthcare Bring Your Own Device Managed IT Services Big Data 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 Telephone The Internet of Things Scam Data loss Social Cooperation Free Resource Project Management Windows 7 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 Maintenance Safety Antivirus Sports Downloads iPhone Mouse Licensing Administration Vulnerabilities Entertainment Data Privacy Images 101 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 Deep Learning Download Net Neutrality Twitter Alerts SQL Server Technology Care Undo Financial Data Error History Business Communications Social Engineering Break Fix Scams Browsers Smartwatch Education Connectivity IT Upload Procurement Remote Computing Azure Hybrid Work Mobile Computing Social Network Telework Cyber security Multi-Factor Security Tech Human Resources 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

Blog Archive