BNMC Blog

Make Excel Data More Exciting

Make Excel Data More Exciting

Microsoft Excel is an extremely useful program for visually displaying data. Having said that, these spreadsheets aren’t exactly the most attention-catching things on their own. Fortunately, Excel has some options built-in that can allow you to display your figures in a more engaging, more expressive, and more meaningful way.

Sparklines and In-Cell Charts
These features help to eliminate the issues with visualization that row-after-row of numbers have, literally drawing the user a picture to put the numbers into context. The Sparkline option simply produces a miniature line, bar, or win/loss graph inside a cell, giving a quick, general-trend reference point.

While the in-cell charts are useful, you can also add an even more basic style and apply custom rules to your cells to reflect this. Let’s assume that the range of data pictured above represents the number of attendees at the last few events your company has thrown, with a goal of at least 16. You can make it even easier to see when this goal was reached, and when it wasn’t, with some conditional formatting.

Selecting your data, click Conditional Formatting in the ribbon above your spreadsheet. Click Manage Rules, and access the new rule you just made for your data set. There, you have a variety of options to explore. For the purposes of this example, we’re going to select arrows as the icon style, set the top two values as 16, and the bottom as 15. Once you Apply this style, you should see this:

This makes it much easier to identify months in which the goal wasn’t quite reached, and from there, make inferences into larger causes.

Sunburst Chart
The sunburst chart is essentially a more broken-down version of a pie chart, each slice further divided into slivers. In doing so, you can add more data into each chart for a more comprehensive picture.

Let’s say you serve three industries, 1, 2, and 3, each with three, uniquely specialized services, A, B, and C, and each service has three tiers, X, Y, and Z. Maybe you want to determine how your sales of each measure up in your total and visually see it.

Once you have all this data divided into the right columns and rows, you can insert the sunburst chart to see it, and make your business decisions accordingly.

Thermometer Chart
Thermometer charts are great for motivation, whether its for an overall sales goal, an internal fundraiser, or any other progressing metric. This one can be a bit tricky, so make sure you follow along carefully.

Let’s assume that we’re tracking progress towards a sales goal of $150,000, and total sales thus far have equaled $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:

How can you think to use these added Excel abilities to display data? Leave your ideas in the comments, and make sure you subscribe to BNMC’s blog!

 

Comments

No comments made yet. Be the first to submit a comment
Already Registered? Login Here
Guest
Sunday, February 17 2019

Captcha Image

Subscribe to Our Blog!

Mobile? Grab this Article!

Qr Code

Tag Cloud

Security Tip of the Week Best Practices Technology Email Cloud Privacy Business Computing Malware Network Security Hackers Google Software Productivity Tech Term User Tips Business Computer Internet Microsoft Mobile Devices IT Services Hosted Solutions Efficiency Communication Ransomware Small Business Hardware Smartphone Android IT Support Data Innovation Managed IT Services Backup Saving Money Windows 10 Browser Windows Cloud Computing Internet of Things Data Recovery Workplace Tips Data Management Managed IT Services Business Continuity Data Backup Productivity Cybersecurity Server Microsoft Office App Business Management Artificial Intelligence Gmail Disaster Recovery Outsourced IT Word Encryption Passwords Vulnerability Remote Monitoring Office 365 Facebook Mobile Device Phishing Upgrade Windows 10 Tip of the week Information Network Money IT Support VoIP Smartphones Employer-Employee Relationship Chrome Applications Managed Service Provider Users BYOD Analytics communications Infrastructure Website Office Tips Robot Data storage Antivirus Save Money Maintenance Automation Big Data Virtual Reality Settings Access Control IT Management Google Drive Government Router Content Filtering Paperless Office Bandwidth Miscellaneous YouTube Company Culture Employee-Employer Relationship Risk Management Display Social Media Managed Service Two-factor Authentication desktop Managing Stress Avoiding Downtime Monitors Vendor Management Scam Firewall Laptop Hacker Development The Internet of Things Document Management Spam Computing End of Support Networking HIPAA Outlook Wireless Operating System Downtime WiFi LiFi VPN Mobile Security Hosted Solution Data Security Gadgets Business Technology SaaS Server Management Administration Mouse Touchscreen Business Intelligence Virtual Private Network Quick Tips Computers Holiday Tablet Apple Retail Alert Education Unified Threat Management Storage Data loss Printing Telephone Systems Address Permissions Digital Payment Computing Infrastructure Professional Services Laptops Legal Office Samsung Social Networking Buisness PowerPoint Password Virtual Desktop Mobility Unified Communications Drones User Error Disaster Chatbots eWaste Sports Windows 8 Patch Management Managed IT Service Tech Support Digital Star Wars Customer Relationship Management Chromebook Collaboration Wearable Technology Network upgrade Specifications Nanotechnology Co-Managed IT Alerts USB Software as a Service Deep Learning Heating/Cooling Social Engineering Multi-Factor Security Motherboard Cables Onboarding Mobile Device Management Print Toner Time Management Printer Uninterrupted Power Supply Identity Continuity Slack Break Fix Websites Fraud Spyware Cost Management Content File Sharing Smart Office Alt Codes Search Black Friday Computer Care IBM Screen Reader Charging Emergency Licensing Dongle Cybercrime Bring Your Own Device Servers Safety Google Calendar Solid State Drive Wires Digital Signage Assessment Shortcuts Budget Network Management Remote Computing Solar Marketing Monitoring Social Dark Web Identity Theft Streaming Information Technology Network Congestion Work Typing Humor Cyber Monday Training Corporate Profile Smart Tech Automobile Cooperation Service Level Agreement Best Practice Legislation G Suite Hard Disk Drive Voice over Internet Protocol Troubleshooting Current Events Microsoft Excel Hotspot Internet Exlporer Security Cameras Writing SharePoint Dell Compliance Spying Wi-Fi Human Error Apps Techology Virtualization Cabling IT Technicians Optimization Halloween Analysis Cryptocurrency Managed IT Smart Technology WannaCry Connectivity How To Dark Data Lenovo Update Google Maps Staff Leominster Google Docs Statistics Modem FinTech IT solutions Going Green Mail Merge Blockchain Language Value Managed Services Downloads Regulations Hacks Device Google Wallet VoIP Unified Threat Management Mirgation Recycling Scary Stories Bitcoin Shortcut Distributed Denial of Service Politics IoT Firefox Customer Service Superfish Augmented Reality K-12 Schools Running Cable Business Growth Bluetooth Comparison Cookies MSP LED Health Private Cloud Cameras Black Market Meetings Tracking Law Enforcement Cleaning Electronic Medical Records Notifications CCTV Twitter Webcam Physical Security Emoji Upgrades Gadget Error Entertainment Crowdsourcing BDR Mobile Computing Point of Sale Ben McDonald shares Personal Information Botnet Cortana Travel 3D Printing Regulation Machine Learning Supercomputer CrashOverride Processors Motion Sickness Unsupported Software Staffing Administrator Taxes Printers Computer Repair Relocation IT Budget Web Server what was your? Mobile Data GPS Recovery How To Work/Life Balance IT Consultant

What Our Clients Say

  • BNMC has provided us with nothing less than outstanding service and results for all of our IT needs for the past few years. Every member of their staff is professional, knowledgeable, friendly and eager to solve any problem...
  • 1
  • 2
  • 3