Fuse Networks Blog

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!

Why Protecting Your Google Account Should Be a Pri...
Technology Basics: Understanding Different “____wa...
 

Comments

No comments made yet. Be the first to submit a comment
Already Registered? Login Here
Guest
Friday, May 24 2019

Captcha Image

Newsletter Sign Up

  • No-Spam Guarantee: We hate spam as much or more than you do and will NEVER rent, share or give your information away to anyone else. We will only use your information to communicate with you direct, and you can also remove yourself from our list at any time with a simple click..
  • Company Name *
  • First Name *
  • Last Name *

      Mobile? Grab this Article!

      QR-Code dieser Seite

      Tag Cloud

      Tip of the Week Security Technology Best Practices Business Computing Tech Term Network Security Innovation Hackers Privacy User Tips Data Android Productivity Computer Software Data Backup Collaboration Efficiency IT Support Cybersecurity Data recovery Email Communication Hosted Solutions Business Management Communications Mobile Device Social Media Hardware Google Internet Small Business Smartphone Phishing Malware IT Services Microsoft Office Office 365 Backup Facebook Mobile Devices VoIP Artificial Intelligence Access Control Apps Cloud Blockchain Managed Service Cloud Computing Network Browser Cybercrime Automation Information Applications Smartphones Business Cost Management Business Technology Two-factor Authentication BDR Microsoft Holiday Workplace Tips Passwords Data Security Users Windows 10 Internet of Things Saving Money Maintenance Vulnerabilities Vulnerability Ransomware Mobile Device Management Scam Websites Analytics Augmented Reality Bitcoin Networking Vendor Server Downloads Healthcare Managed IT services Data Breach Tech Terms Document Management App Mobility Apple Virtual Assistant Quick Tips Alert Disaster Recovery Printer Upgrade Patch Management Conferencing Hacking IT Management Data loss Outsourced IT Google Maps Social Engineering Saving Time Remote Monitoring Government Bandwidth Cooperation Update Gmail Legal Upload Cost Comparison Chromebook Computing SharePoint Downtime Medical IT Accountants Encryption Desktop Transportation Knowledge Google Calendar Fuse Networks Compliance Social News Mobile Technology IT Retail Cleaning BYOD email scam HTML Tactics Electronic Medical Records Law Enforcement Legislation Trends Digital Multi-factor Authentication Microchip Specifications Backup and Disaster Recovery Error project management Piracy Proxy Server Data Management Training Productivity Entertainment Private Cloud Business Cards Sports Regulations Router Fake News Virtual Reality Support Windows 7 Cortana Computers Gadgets Budget eWaste VPN Tech Addiction WiFi Gamification Device security Processor Television Twitter Telephone Money Software License Help Desk PowerPoint Managed Service Provider Unified Communications Equifax Service Level Agreement Big Data Excel Antivirus Data Analysis Business Continuity Google Docs Screen Reader Modem Website Microsoft Excel Company Culture CIO Microsoft 365 Disaster Nanotechnology Robot Data Protection Term Audit Emails Customer Service Navigation Mouse Social Network Miscellaneous Vendor Management Professional Services Printing Startup Going Green Tip of the week Fileless Malware Monitoring User Tip SSID Machine Learning Identity Theft Bookmark Solutions Emergency Operating System Travel Google Play Voice over Internet Protocol Bluetooth Spam Hard Drive Paperless Office Customer Resource management Distributed Denial of Service Information Technology Download Windows 10 Managed IT Services Mobile Security Directions Management Computer Care Network Management Cryptocurrency Laptop Browsers Integration Username Computing Infrastructure Health IT Devices Security Cameras NCSAM iPhone Virtualization Wireless Headphones Content Hard Drive Disposal Evernote Database Telephone System Freedom of Information Hard Drives Lithium-ion battery Search 5G Tech Support Wireless Technology IBM Safety The Internet of Things Marketing Hacker Customer Relationship Management Competition Avoiding Downtime Regulation IP Address Hiring/Firing Employer/Employee Relationships Mobile Office Domains Fun Employer-Employee Relationship Managing Stress Wireless Printers Public Speaking Multi-Factor Security Presentation Wi-Fi