Home

About Us

IT Services

Electronic Security

Knowledge Center

News & Events

Blog

Support

Contact Us

Prosper IT
  • Register

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

Comments

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

Captcha Image

Mobile? Grab this Article!

QR-Code dieser Seite

Tag Cloud

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

Latest News & Events

Prosper Solutions is proud to announce the launch of our new website at http://www.prospersolutions.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 ser...

Contact Us

Learn more about what Prosper Solutions can do for your business.

Call Us Today
Call us today
(617) 369-9977

150 Eastern Ave, Second Floor
Chelsea, Massachusetts 02150