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

Captcha Image

Mobile? Grab this Article!

QR-Code dieser Seite

Tag Cloud

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

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