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
Friday, March 22, 2019

Captcha Image

Mobile? Grab this Article!

QR-Code dieser Seite

Tag Cloud

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

Newsletter Sign Up