facebook linkedin twitter

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...
Get the Technology Your Company Requires


No comments made yet. Be the first to submit a comment
Already Registered? Login Here
Saturday, January 19, 2019

Captcha Image

Mobile? Grab this Article!

QR-Code dieser Seite

Tag Cloud

Security Tip of the Week Technology Best Practices Privacy Internet Cloud Software Business Computing Hackers Business Management Microsoft Data Workplace Tips Managed Service Provider Backup Productivity Hardware Business Saving Money Network Security Malware Email IT Services Hosted Solutions Efficiency IT Support Google Small Business Computer Quick Tips Mobile Devices User Tips Smartphones Gadgets Innovation Business Continuity Disaster Recovery Social Media Microsoft Office Android Mobile Office Virtualization Network VoIP Data Backup Mobile Device Management Collaboration Communication Server Smartphone Data Recovery Productivity Miscellaneous Windows 10 Upgrade Tech Term Ransomware Unified Threat Management Windows IT Support Operating System Passwords communications Holiday Remote Monitoring Facebook BYOD Remote Computing Managed IT services Vendor Management Apps Cybersecurity Mobile Computing WiFi Phishing BDR Users Mobile Device Marketing Analytics Automation The Internet of Things Apple Firewall Outsourced IT History Save Money Data Management Alert Artificial Intelligence Internet of Things Managed IT Services Browser App Encryption IT Consultant Big data Health Content Filtering Going Green Office Bring Your Own Device Gmail Maintenance Antivirus Printer Spam Bandwidth Cybercrime Hiring/Firing Hard Drives Managed IT Cost Management Saving Time Information Technology Lithium-ion Battery Best Practice Business Technology Office 365 Budget Windows 8 Outlook Help Desk Two-factor Authentication Wireless Technology Windows 10 Search Cloud Computing Tech Support Virus Document Management Employer-Employee Relationship Access Control Computers Phone System Hacking VPN Travel Blockchain IBM Training Update Recovery Money Managed Service Compliance Proactive IT Data storage Running Cable It Management Intranet Twitter Networking Education Information Legal Regulations Risk Management Healthcare Hard Drive Customer Service SaaS Save Time Humor Administration Mobility Applications Government Website Law Enforcement Comparison Tablet Company Culture Word Solid State Drive Avoiding Downtime Computer Repair Password Cortana Flexibility iPhone Value Social Networking Black Market Cryptocurrency Machine Learning Current Events Data Security Hacker Laptop Excel Telephone Systems Business Growth Patch Management Customer Relationship Management Data Loss Scam User Augmented Reality PowerPoint Fax Server Paperless Office File Sharing Sports Social Data Breach Wireless Google Maps Computing Disaster Business Intelligence End of Support Project Management Digital Payment Hosted Solution Digital DDoS Router Robot Downtime Websites Social Engineering Securty Computing Infrastructure Hack Mobile Technology Inbound Marketing Software as a Service How To Trending Conferencing Retail eWaste Private Cloud Mouse Bluetooth Uninterrupted Power Supply Download Programming Bitcoin Statistics Pain Points Monitoring Telephony Data Protection Microchip Taxes Google Docs Network Congestion Processors Co-managed IT Distributed Denial of Service User Error Experience Monitors USB Cleaning Management Office Tips Public Cloud Presentation Streaming Media Vulnerabilities YouTube Redundancy Identity Theft Virtual Desktop Lifestyle Gaming Console Specifications Safety Vendor Unified Communications Net Neutrality Settings Evernote Documents Webcam Chrome Text Messaging Virtual Reality Heating/Cooling Entertainment Politics Automobile Storage Emails Computer Accessories IT service Start Menu Tech Terms Chromebook Messenger Tracking switches Smart Phones Writing Emergency Data Analysis Hard Drive Disposal HTML Best Available Keyboard Get More Done Music Access Fiber-Optic Database Printer Server Upgrades Microsoft Excel Mobile Security Turn Key LinkedIn Computer Care GDPR Telephone System Rental Service Domains Meetings Google Drive Windows Server 2008 Software License Trends Cabling LiFi Leadership Tech Multi-Factor Security Cost Public Speaking Web Server Trojan Adminstration Pirating Information Books Workers Organize Archive Vulnerability Fileless Malware Devices Wi-Fi Shortcut Administrator Skype Spyware Mobile Payment Fraud Tactics Deep Learning Proxy Server UTM Content Entrepreneur Work/Life Balance Electricity Printing Modem Troubleshooting Supercomputer Electronic Medical Records Windows 7 IT Plan Enterprise Resource Planning Environment Worker Visible Light Communication Memory Term Legislation Error HIPAA Point of Contact Addiction Electronic Payment Reading Samsung IT consulting Directions Accountants A.I. Competition cache Television email scam Webinar Dark Web Multi-factor Authentication G Suite Upselling WannaCry Downloads SSID Business Owner Employer Employee Relationship Analytic Video Surveillance Time Management Health IT Freedom of Information Migration Connected Devices Licensing Recycling Advertising Flash Corporate Profile Processing Wireless Headphones Telephone Hacks IP Address Physical Security CIO SharePoint Network Management Relocation Human Resources Tablets Windows XP Saving ZTime Managed IT Service Equifax Fleet Tracking Banking Application Botnet Staffing Google Wallet Product Reviews Assessment Displays Read Bookmark Tip of the week Device security MSP Sync Society Google Calendar Micrsooft Debate Touchscreen News Desktop Finance Harddrive VoIP Google Play Nanotechnology Social Network Notifications CCTV Consultation Business Cards Service Level Agreement Reliable Computing Device Management Knowledge Processor Startup Asset Tracking Digital Signature Business Metrics Computer Malfunction Best Practives Drones GPS External Harddrive Content Management Browsers Virtual Assistant Username Teamwork In Internet of Things Business Managemenet Technology Tips Unified Threat Management Backup and Disaster Recovery User Tip Fake News Gamification Microserver Permissions Language Audit Security Cameras Screen Reader Customer Resource management Data Warehousing Piracy Upload PDF Scalability online Currency Thin CLient Navigation Smart Tech Distribution Motion Sickness 3D Ebay Printers Managing Stress Productuvuty Regulation 3D Printing CrashOverride Cooperation Medical IT Capital