Our Blog: Stuff we think you should know

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 Haber Group’s blog!

The Top 5 Smartphones On the Market Heading Into 2...
Tech Terminology: Mobile Device Management
 

Comments

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

Captcha Image

Mobile? Grab this Article!

Qr Code

Tag Cloud

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