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

Blog Archive