Get Started Today!  217-475-0226

croom new

Decatur Computers Inc. 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, February 22 2019
If you'd like to register, please fill in the username, password and name fields.

Captcha Image

Mobile? Grab this Article!

Qr Code

Tag Cloud

Tip of the Week Security Best Practices Technology Network Security Privacy Business Computing Tech Term Hackers Productivity IT Support Software Data Backup Data Innovation Efficiency Android Google Business Management Data Recovery Malware User Tips Internet Email Computer Communications Cybersecurity Collaboration Smartphone IT Services Cloud Small Business Windows 10 Backup Ransomware Communication Managed IT Services Hosted Solutions Mobile Device Phishing Hardware BDR VoIp Facebook Browser Artificial Intelligence Microsoft Office Business Technology Social Media Mobile Devices Managed Service Automation IT Management Blockchain Cybercrime Business Cost Management Information Access Control Office 365 Outsourced IT Mobile Device Management Cloud Computing Applications App Encryption Scam Websites Server Network Two-factor Authentication Microsoft Passwords Apps Smartphones Hard Drive Maintenance Update Antivirus Gadgets Workplace Tips Data Management Managed IT Services Saving Money Disaster Recovery Holiday Patch Management Data Security Saving Time Printer Laptop Save Money VPN Vulnerability Alert Internet of Things Bitcoin Mobility Operating System Analytics Law Enforcement Social Engineering Conferencing Healthcare Data loss Remote Monitoring Hacking Apple Tech Terms Business Continuity Gmail Money Vendor Project Management Search Spam Vulnerabilities Big Data Data Breach Word Touchscreen Users Digital SaaS Managed Service Provider Augmented Reality Data Protection Document Management Google Maps Bandwidth Windows Quick Tips Cooperation Start Menu Networking Legislation Going Green Freedom of Information Mobile Security Computing Security Cameras Accountants Running Cable Spyware User Tip Mouse Company Culture IBM Evernote Unified Communications Cortana Electronic Medical Records Medical IT Redundancy Budget Cleaning Solid State Drive Upgrades Content Fileless Malware Audit HTML Administration Samsung Business Cards Virtualization Unified Threat Management Download Bookmark Knowledge News Paperless Office Tablet Software as a Service Error Social eWaste Training Cabling Addiction DDoS Identity Theft Corporate Profile Time Management Miscellaneous Printing Health IT PowerPoint Information Technology Computers BYOD Directions Virtual Assistant Employer-Employee Relationship Managed IT Password Upload Browsers Fake News Multi-factor Authentication Database How to Telephone Router Robot Equifax WiFi Machine Learning Proxy Server Desktop Chromebook Automobile Tech Government Professional Services Comparison Mobile Technology Nanotechnology Uninterrupted Power Supply Google Drive Telephone Systems Microchip Computer Care Excel Devices Google Calendar Downtime Emails Best Practice Trends Device security Tactics IT Support Virus Social Network Modem Startup Worker Wireless Network Management Help Desk SharePoint Backup and Disaster Recovery Unified Threat Management Monitoring Term Legal Sports Specifications Telephony Consultant Travel Processor Tip of the week Hard Drive Disposal Compliance Outlook Voice over Internet Protocol Piracy Bluetooth Vendor Mangement Unsupported Software Gamification Entertainment Microsoft Excel Website YouTube Customer Resource management SSID Computing Infrastructure Service Level Agreement Vendor Management Disaster Distributed Denial of Service Twitter Management Google Play Downloads Regulations Access Emergency Television Virtual Reality Screen Reader History VoIP Username Navigation email scam Telephone System Google Docs iPhone Software License Wireless Headphones Business Mangement Data Analysis Cryptocurrency Settings Retail Printers CrashOverride Windows 10 Marketing Regulation Office Multi-Factor Security Office Tips Managing Stress

Latest Blog

Sometimes threats come to light only after they’ve been around for long enough to cause concern for the public. This was the case with a new bug found in Apple’s FaceTime app that allowed users to spy on others without their consent through group FaceTime calls. Thankfully, ...

Latest News

Decatur Computers Inc. is proud to announce the launch of our new website at http://www.decaturcomputers.com. The goal of the new website is to make it easier for our existing clients to submit and manage support requests, and provide more information about our services for prospective clients.