Out of the Box Solutions 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, January 22 2019

Captcha Image

Mobile? Grab this Article!

Qr Code

Tag Cloud

Tip of the Week Security Best Practices Technology Business Computing Network Security User Tips Tech Term Privacy Productivity Internet Cybersecurity Smartphones Efficiency Android Communication Malware Hardware Mobile Device Browser Microsoft Network Small Business IT Support Cloud Data Ransomware Email Passwords Windows 10 Wi-Fi Mobile Devices Data recovery Internet of Things IT Services Communications Applications Wireless Holiday Users Backup Business Management Saving Money Managed IT services Collaboration Innovation Data Backup Google Blockchain Hosted Solutions VoIp Software Information Marketing Networking Business Hackers Outsourced IT Workplace Tips Social Media Managed IT Services Cloud Computing Business Intelligence Employer-Employee Relationship VPN BDR Gmail Data Management Remote Monitoring and Management Computers Save Money Tech Terms Access Control Microsoft Office Automation Managed IT Service Connectivity Medical IT Remote Computing Smartphone Patch Management Facebook Artificial Intelligence Computer Apps Cost Management Analytics Bandwidth Virtual Assistant Password Managed Service Mobility Wireless Charging Cortana Compliance Virtualization Touchscreen Spyware Cybercrime Telephony Proactive IT Help Desk Backup and Disaster Recovery Downloads User Tip e-waste G Suite Data Breach Outlook Big Data Sports WannaCry Server Management Data Protection RAM Workers Edge Virus Safety Threat Specifications Security Cameras Server Microsoft Office 365 HP Tactics Voice over IP Business Continuity Settings Hard Drives Trends disposal Bring Your Own Device Sales Profitability Gadgets Storage HIPAA Mobile Security Microsoft Teams Millennials Miscellaneous Antivirus Printing Reporting Word Document Management Telecommute Upgrade IT budget SSD A.I. Hard Drive Value Hybrid Cloud Tablet Amazon Eliminating Downtime Physical Security Dark Web Operating System Company Culture Business Technology Staff Dongle Paper Conferencing Wearables Lead Generation Network Attached Storage Authentication Paperless Office Maintenance Analysis Certification Battery Movies Processors Cables Excel BYOD eCommerce Laptop Technology Tips Error Managing Stress Troubleshooting Ink Office SaaS Healthcare Telecommuting Authorization Digital Data loss Router Twitter Vulnerability Machine Learning Database Voice over Internet Protocol Knowledge Office 365 Plug-In Wireless Internet Online Shopping Streaming Media Tip of the week Environment Phishing Update Government PowerPoint Content Filtering GDPR Data Security Unified Communications Spam Websites Internet Explorer Comparison Training IT Management Inventory Personal Information Disaster Recovery Regulation Alert Printers Quick Tips