888.678.7282    Get SUPPORT

Strata Information Technology Blog

Tip of the Week: Use Excel to Create Eye-Catching Visuals

Tip of the Week: Use Excel to Create Eye-Catching Visuals

Spreadsheets are excellent ways to communicate a lot of information in a concise format. However, the big problem is that a spreadsheet alone isn’t very visually appealing. To remedy this, you can add other visual elements, like charts, into your Microsoft Excel spreadsheets. For today’s tip, we’ll go over some of your options.

Choosing Your Chart
Excel provides plenty of chart designs to choose from, but most are overly extravagant or overly complicated for typical business purposes. You will generally be able to present your information adequately by using a column/bar, pie, or line chart.

Types of Charts
Column
Column charts are best used to demonstrate a change in data values over time, or to compare values of multiple things at a single point. For instance, you could use a column chart to show the frequency of ransomware attacks over time, or to compare the frequency of multiple types of malware at a given point to one another.

Bar
A bar chart is essentially the same thing as a column chart, only rotated to be horizontal. These are helpful to use when the discrepancy between your data points is especially large, or when you need more space to fit your axis labels.

Pie
A pie chart is useful when you need to compare the percentages of a group of data. For example, let’s say a company experienced 10 downtime events in a month. A pie chart would be used to tell us that 30% of these attacks were ransomware attacks, 20% were DDoS attacks, and 50% were user error.

Line
A line chart is most useful when you’re trying to show how data changes over time, and allows you to display multiple data trends simultaneously. So, to return to the example shared for the column/bar charts, a line chart can demonstrate the frequency of multiple types of malware while simultaneously comparing their frequency, as compared to choosing between the two with a column/bar chart.

Building Your Chart
Excel makes it fairly simple to create a chart based on the data contained in a spreadsheet. The first step is simply to organize the data in your spreadsheet before highlighting what needs to be included in your chart.

Once that is done, click Insert and then select the chart style you want to use, either from the list of Recommended Charts, or from All Charts. Your new chart should appear. You can then use the Chart Elements, Chart Styles, and Chart Filters to customize the information that is presented in the chart to better make your intended point.

There are many more options available to customize your chart further. A bit of exploration, experimentation, and liberal use of the ‘Undo’ feature will allow you to craft a chart that clearly communicates the point you’re trying to put across.

Make sure you subscribe to our blog for more handy IT tips and computing tricks!

For Benefits over Your Old Phone System, Dial VoIP
New Year’s IT Solution: Outsource IT
 

Comments

No comments made yet. Be the first to submit a comment
Already Registered? Login Here
Guest
Friday, February 15 2019
If you'd like to register, please fill in the username, password and name fields.

Captcha Image

Mobile? Grab this Article!

QR-Code dieser Seite

Tag Cloud

Tip of the Week Security Business Computing Technology Best Practices Managed IT Services Privacy Cloud Network Security Malware Internet Hackers Communications User Tips Cybersecurity Software Tech Term Productivity Ransomware Backup Business Management Smartphones Outsourced IT VoIP Efficiency Microsoft Passwords IT Support Alert Business Hardware Email Productivity Data Data Recovery Browser IT Services Innovation Network Google Social Media Data Backup Windows 10 Communication Small Business Cloud Computing Mobile Device Smartphone Microsoft Office Phishing Holiday Users Collaboration Save Money Hosted Solutions Apps Vulnerability Data Breach Miscellaneous Android Saving Money App Bandwidth Access Control Twitter Internet of Things Business Continuity Facebook Law Enforcement Workplace Tips Blockchain Patch Management Workers Office 365 Personal Information Settings Employer-Employee Relationship Remote Monitoring Scam Excel Company Culture Cybercrime Networking Politics Wireless Government Mobile Device Management Mobile Devices Wi-Fi Computer Compliance BDR Applications Entertainment Recovery Marketing Antivirus Maintenance Password Retail Computers Office Website Data Security BYOD Education Medical IT Vendor Management Automation Managed IT Service SaaS Spam Dark Web Managing Stress Chrome Virus Information Remote Monitoring and Management Windows Word Virtual Assistant Connectivity How To Error Data loss Gadget Safety Help Desk Telephone System WannaCry Unified Threat Management HP Biometrics Sales Managed Service Provider Cost Management Streaming Media Outlook Travel Business Intelligence The Internet of Things Regulation Vulnerabilities Cleaning Printers Gadgets Budget Troubleshooting Physical Security Technology Tips Hybrid Cloud Healthcare WiFi Managed IT Access Touchscreen Router Content Filtering Hiring/Firing Employer Employee Relationship Staff RAM Current Events Shortcut Certification HIPAA Botnet VPN Document Management Database Leadership Tablet Downloads Managed Service Live Streaming Reporting Encryption Computer Care VoIPMyths Files Battery Data Management Backup and Disaster Recovery Cables Plug-In Telephone Systems Data Protection Microsoft Office 365 Gmail Automobile Websites Microsoft Teams Net Neutrality CrashOverride Mobility Remote Support Hard Drive Paperless Office Tactics Knowledge Artificial Intelligence Trends Profitability WhatsApp Wireless Charging Synergy e-waste Disaster Recovery Upgrade IT budget PowerPoint Gaming Console VoIPSavings Yahoo SSD Voice over Internet Protocol Proactive IT E-Commerce Remote Control Internet Explorer Analytics Authentication Training Processors Digital GDPR Comparison Hard Drives A.I. Scalability Phone System Eliminating Downtime Lead Generation disposal IT Management Sports Video Games Google Maps Update Emergency Telephony DDoS Inventory Payment Edge Threat IaaS Two-factor Authentication Authorization Dongle Worker Security Cameras Apple Storage Multi-Factor Security Specifications Avoiding Downtime Movies Credit Cards Wireless Internet News Dark Data Spyware Value Television Information Technology Tech Terms Staffing Technology Efficiently Licensing Voice over IP Amazon Smart Technology instant Messaging Email Management HaaS Printer Server Tech Support Cortana Bring Your Own Device Printer iPhone IBM Conferencing Unified Communications Network Attached Storage Managed IT Services Hacker eCommerce Operating System Paper Telecommuting Customer Relationship Management Competition Cryptocurrency Server Management IP Address Online Shopping Environment Big Data Ink Millennials Fun Customer Service Google Drive Mobile Office IT Support Hosted Solution Domains File Sharing User Tip Virtualization Autocorrect Machine Learning Search Scheduling Copy Public Speaking Spam Blocking User Security Tip of the week Server G Suite Windows 10 Presentation Telecommute VoIP Lithium-ion battery Emoji Business Technology Instagram Mobile Security Paste Augmented Reality Laptop Printing Quick Tips Remote Computing Samsung Wireless Technology 5G Wearables Money

Newsletter Sign Up