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, March 25 2019

Captcha Image

Mobile? Grab this Article!

Qr Code

Tag Cloud

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