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
Monday, December 10 2018

Captcha Image

Subscribe to Our Blog!

Mobile? Grab this Article!

Qr Code

Tag Cloud

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

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