Our Most Popular Managed Services

If you need help deciding what services are best for your business let us know.

Logo

 
 Popular Services
 (347) 830-7322

Logo

 

Tekie Geek Blogs

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...
Technology Basics: Understanding Different “____wa...
 

Comments

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

Captcha Image

Mobile? Grab this Article!

QR-Code dieser Seite

Tag Cloud

Big Data Visible Light Communication Botnet G Suite Evernote Social Network Data Analysis Mobile Security Hardware IT support firms Virtual Reality Database IT Management Deep Learning Windows XP Search SaaS Collaboration Unified Threat Management Startup Tablet it support Regulations computer repair Printing Maintenance Telephone Computers Microchip Hiring/Firing IT services Staten Island Document Management Server Business Growth IT support New York City Phishing Worker History Google Calendar IT consulting Staten Island Computer Malfunction staten island managed services Safety Cabling Machine Learning Retail Username Managed Service Domains Web Server Tip of the week Digital Payment Backup and Disaster Recovery Cloud Vendor Management Streaming Media Business Computing computer support BDR Social managed IT services staten island Automation Mobile Device end-user files Information Workplace Tips Legislation Meetings IT consulting firms DDoS Excel SSID Mobile Technology YouTube Knowledge Saving Time Going Green Content Filtering Employer-Employee Relationship Router Tech Support Office 365 Microsoft Office Upload Paperless Office Hardware Solutions Efficiency Update Health Android Managed Service Provider Congratulations Network Security Applications Sports Touchscreen Hacking managed it services Telephone System Outlook communications Productivity Mobile Device Management Technology Business Cards Securty computer support Staten Island IT Consultant Internet Business Mobile Devices Computing IT support NYC Virtualization Hosted Solution Staten Island computer support Start Menu Office Tips Drones Word Patch Management Government Twitter Settings Encryption Desktop tech support Staten Isalnd Thank You Fake News Google Play Education Webcam Remote Computing Hacker Business Metrics Cortana Lenovo Software License computer services Staten Island Google Maps Bitcoin Workers Downloads Information Technology data loss Work/Life Balance Software Browsers Miscellaneous tech support Telephone Systems Modem Multi-Factor Security Data Backup Music Hard Drive Disposal VPN Equifax Save Money Ransomware Smartphone Travel Writing Addiction Staffing Networking computer services Spam Samsung Managing Stress CCTV Flash Websites IT consulting Staten island Cloud computing Staten Island Computer Care Spyware Taxes Saving Money Devices Managed IT Services Private Cloud Gamification Processor Productivity Money Tablets Business Technology Healthcare Quick Tips Processors Virtual Assistant Bluetooth IT consulting NYC Distributed Denial of Service Cache Telephony Society Proactive IT Small Business Social Media How To Navigation Data Breach Best Practices Health IT Network Management Television Office Security Cameras Managed IT Services Cryptocurrency Piracy Apple In Internet of Things Business Management Communication Wireless Headphones Staten Island IT consulting Disaster Recovery Apps 3D Printing IT services NYC Browser Help Desk CryptoLocker malware Hard disk Advertising Vendor Mangement End of Support IT consulting firm Firewall Unified Communications The Internet of Things Powerful Technology Solutions Passwords IT services New York City Computer Law Enforcement Hackers Access Language Windows 10 Term HTML Website Redundancy Virtual Desktop Augmented Reality ransomware attacks Fileless Malware IT consulting company Download IBM Cleaning Laptop Monitoring Wireless Technology Antivirus Documents datto Cloud Computing BYOD Running Cable Security Business Continuity Windows 10 Privacy Smartphones malware worms Notifications Upgrade Workstations eWaste Displays Backup Black Market Administration VoIP Compliance Hosted Solutions Electronic Medical Records IT support Staten Island Tip of the Week IT support Directions computer support NYC Accountants Digital Microsoft Excel Hacks Nanotechnology Training Robot Data Security Service Level Agreement Screen Reader Hack Tactics Uninterrupted Power Supply Entertainment Proxy Server Specifications Recovery Banking Microsoft Downtime Data storage Hard Drive VoIP Scalability IT Support Windows 8 Best Practice Supercomputer Content Two-factor Authentication Relocation File Sharing Cybercrime Conferencing Reliable Computing email scam Vulnerability Accidental deletion Motion Sickness SharePoint Bookmark data recovery Budget Flexibility Trends Experience Blockchain Project Management Staten Island IT support Printers Lithium-ion battery Mobility Data Remote Monitoring LiFi Management Facebook computer support firms WiFi Employer Employee Relationship User Tip Bring Your Own Device Time Management Tech Terms Mouse Managed IT Network App managed services Staten Island tech support User Tips computer repair Staten Island IT support Staten Islans Cybersecurity Gadgets Emergency Social Engineering managed IT services NYC News Legal managed services Staten Island Operating System Data Protection Administrator Rental Service Google Drive Multi-factor Authentication Laptops Public Cloud Unified Threat Management Solid State Drive today ’s organizations Tracking Disaster Wi-Fi Alert Corporate Profile Scam Bandwidth Computing Infrastructure Chromebook Vendor Monitors Gmail PDF Error Audit Wireless Innovation Google Docs Windows Virus tech support Staten Island Comparison Software as a Service Outsourced IT Memory Vulnerabilities Company Culture Analytics Device security Physical Security Regulation Text Messaging Business Mangement Google Google Wallet IT Services Password Holiday Malware Email Tech Term Tech Printer Customer Service Internet of Things Access Control Freedom of Information Emails Data Management Artificial Intelligence Cost Management data recovery Staten Island Network Congestion IT consulting Users CrashOverride Customer Resource management Politics Automobile Identity Theft

Newsletter Sign Up