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
Saturday, April 20 2019

Captcha Image

Subscribe to Our Blog!

Mobile? Grab this Article!

Qr Code

Tag Cloud

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

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