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

Newsletter Sign Up