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
Thursday, January 17, 2019

Captcha Image

Mobile? Grab this Article!

QR-Code dieser Seite

Tag Cloud

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

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