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.

Other Options for Visual Excel Data

Other Options for Visual Excel Data

If you need to condense data into a concise and comprehensible form, Microsoft Excel is tough to beat. This is despite the fact that your average spreadsheet isn’t exactly an eye-catcher. However, Excel provides a few native options that boost your data’s visual appeal, making it more engaging and much more meaningful. We’ll review a few today.

In-Cell Charts and Sparklines
One of the biggest downsides to line after line and row after row of numbers and labels is that it becomes difficult to visualize any patterns. Both of these functions resolve that by providing clear visual cues.

Excel’s Sparkline option displays a miniaturized line graph, bar graph, or win/loss chart within a cell. This adds an added layer to the visualization. So, let’s say you want to track how many sales were made of a certain product or service offering. With a line graph Sparkline, you can create this quick reference:

You also can go even more in-depth with your styling, applying custom rules to your cells to display more granular information. Let’s assume that your goal for these specific sales was to complete at least 16 per month. Utilizing conditional formatting can make it even more obvious when this goal was (and wasn’t) reached.

With your data selected, select Conditional Formatting from the menu ribbon. Click Manage Rules and access your newly-created rule for the data set. You can then play with some of your options. In this example, we decided to use arrows as our icon style and identify 16 as both of our top values and 15 for the bottom. After you hit Apply, your data should appear like this:

As a result, you can see much more quickly which months saw enough sales to reach the set goal, and which did not. This makes it easier to identify other events that may have influenced these numbers and act accordingly.

Turning Pies into Sunburst Charts
A sunburst chart is effectively the combination of multiple pie charts into a single, unified representation. This helps you to spot important patterns that may have been missed if the graphs were left separated.

For example, let’s say you serve a variety of industries, and have specific services for each, with each service divided into tiers. By labelling each industry as 1,2, and 3, with services A, B, and C, and the tiers X, Y, and Z, you can create a sunburst chart that allows you to compare how these sales play as a part of your incoming revenue.

One this data has been divided as pictured, you can apply the sunburst chart to see the following hypothetical:

So, while you can see from the data that service 3CY outperforms any other on this chart (most by a considerable margin) by reviewing the data, the sunburst chart provides considerably more insight into this fact - primarily, the significance of such a difference. From there, you can again examine some of the factors surrounding these outcomes and adjust accordingly.

Raising the Bar with a Thermometer Chart
Thermometer chart are great for providing some motivation to your team toward a goal, although it does tend to be used primarily for financial benchmarks. However, this one can be a challenge, so be careful as you follow along.

Sticking to the sales usage, let’s say our penultimate goal is $150,000, and there has been $37,163.48.

  • In Excel, insert cells that look like this:
  • Selecting them, click Insert, and under the Column Chart options, add a Clustered Column Chart item. With this item selected, click Switch Row/Column in the menu bar at the top of your screen.
  • Right-click the Total Sales bar and select Format Data Series, then in the Series Options page, select Secondary Axis. You should now only see one bar, with labels on both sides.
  • Right-click the label on the left and select Format Axis. The Axis Options Pane should appear. In the box for Maximum, type in your goal of $150,000. Repeat this process for the label on the right.
  • Right-click the Goal Bar and select the Format Data Point option. Under Fill & Line in the menu that appears, select No fill and make the border a Solid line. Repeat this process with the Total Sales Bar, skipping the “No fill” part and selecting the color you want instead.
  • Finally, you can delete the labels on the bottom and sides (if you wish), as well as the horizontal lines, leaving you with the finished product:

What kind of data would you express better, now that you have these tools to leverage? Share your thoughts in the comments!

 

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

Blog Archive