Home

About Us

IT Services

Electronic Security

Knowledge Center

News & Events

Blog

Support

Contact Us

Blog
  • 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
Monday, March 25, 2019

Captcha Image

Mobile? Grab this Article!

QR-Code dieser Seite

Tag Cloud

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

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