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

Blog Archive