MERIT Solutions Blog

MERIT Solutions has been serving the Chesapeake area since 1982, providing IT Support such as technical helpdesk support, computer support, and consulting to small and medium-sized businesses.

Tip of the Week: Use Excel Like a Pro - Graphing

Tip of the Week: Use Excel Like a Pro - Graphing

Excel is the premier spreadsheet builder, and it’s extremely valuable that your organization get the most out of it. Spreadsheets are ideal for showcasing information in a compact manner, but without a couple of charts, your users will just be staring at cell after cell of boring old numbers. By using charts in Excel, you can take your spreadsheet building to the next level.

Select Your Chart
Excel has several built-in chart types that you can choose from, with many of the more complex ones being a little difficult to use for normal business purposes. You can easily get your point across with a simple column, pie, or line chart.

Column/Bar Charts
Column charts are used best when you need to show how much data has changed over a certain period of time. You can also use them to compare values at a single data point. For example, you could use a column chart to show the revenue earned by individual sales people.

You use a bar chart to do mostly the same thing as a column chart, only it’s horizontal rather than vertical. These are very useful to show particularly large discrepancies between data, or when you need to label your points.

Pie Charts
A pie chart is great if you need to compare percentages according to a group of data. Let’s say that you are tracking how new customers say they find your business. You can break them out into a pie chart to compare and visually explain the bigger slices.

Line Charts
You can use a line chart to see how your data changes over time, as it allows you to showcase multiple data trends all at the same time. With the aforementioned examples above, a line chart could be used to showcase the frequency of how often these threats made themselves apparent on your network.

Building the Charts
Excel has a simple chart building tool that you can use to showcase data from a spreadsheet. First, you want to make sure your data is properly organized in the spreadsheet. Next, highlight what data you want to show in your chart.

Once you’ve done this, just select the chart type that you want to use. You can do so either in the list of Recommended Charts, or from the list of All Charts. You’ll then see your new chart appear. You can further customize your chart by using Chart Elements, Chart Styles, and Chart Filters.

You can use other options to further customize your chart, and with a little bit of improvisation, you can build a chart that both accurately represents your data and gets your point across in the most effective way possible.

To learn more about technology tips and tricks, be sure to subscribe to our blog.



No comments made yet. Be the first to submit a comment
Already Registered? Login Here
Friday, June 22 2018

Captcha Image

Tag Cloud

Security Tip of the Week Technology Best Practices Cloud Privacy Business Computing Network Security Hackers Malware Software Productivity Internet Hosted Solutions Business Management Backup google Computer Managed IT Services Microsoft Mobile Devices Outsourced IT Disaster Recovery Business Continuity Business communications VoIP Windows 10 IT Support Email User Tips Hardware Innovation Cybersecurity IT Services Data Backup Efficiency Cybercrime Server Mobility Tech Term Apps Ransomware Saving Money Mobile Device Management Windows Managed IT Data Recovery Small Business Smartphone Law Enforcement Internet of Things Productivity Operating System browser Data BDR Office 365 Save Money Android Telephone Systems Virtualization Phishing Money Data Security Smartphones Hosted Solution Cloud Computing Quick Tips Passwords Managed Service Provider Chrome Information Technology Communication Recovery VPN Microsoft Office Password BYOD Automation Holiday Alert Application Health Miscellaneous Computers upgrade Social Data Breach Best Practice Social Media Two-factor Authentication App Wireless Budget Data Management Risk Management Unsupported Software Facebook Network Government Collaboration IT Support Update Work/Life Balance Cost Management Google Drive Hacking Gadgets Avoiding Downtime Wi-Fi Vulnerability Spam Antivirus Current Events Social Engineering Audit Managed IT Services Office tips Streaming Media Applications Private Cloud History Compliance Remote Computing Personal Information Proactive IT Politics search The Internet of Things Cleaning USB Save Time Employer-Employee Relationship User Error Data Protection Identity Theft Tech Support Gmail Artificial Intelligence Flexibility Shortcut Wireless Technology Workplace Tips Firewall Telephony Fraud Mobile Computing Transportation Samsung Wireless Charging Television Excel Content Filtering Battery Robot Data Storage HaaS Apple OneNote End of Support WiFi Automobile Project Management Value Going Green Bandwidth Data Loss Saving Time eWaste Marketing Humor Disaster Google Docs Office Computer Care Phone System Legal Management Users Sports Encryption Blockchain Redundancy Commerce Hacker Solid State Drive Mobile Security Big Data Internet Exlporer Devices Cortana IT solutions Patch Management Windows 10 Google Assistant Education Router iPhone Vendor Management DDoS SaaS Computer Forensics Word Benefits Exchange Distributed Denial of Service Managed IT Service altivista Legislation Text Messaging Hard Drive Unified Threat Management iOS SBS PowerPoint Windows Ink Edge Entertainment compaq Comparison Virus Training Evernote Chromebook Upgrades Regulation Electronic Medical Records Computer Fan Wireless Internet Google Maps Ciminal Wearable Technology Point of Sale Company Culture Screen Mirroring HIPAA hp Specifications Proactive Networking Smart Tech Consultant Laptop Sync Safety Uninterrupted Power Supply Dark Web Black Market domain Gamification Software as a Service Smart Technology Meetings Cast Emails Avoid Downtime Sales Websites Workers Connectivity Touchpad Adobe Shadow IT Document Management remote Memory Reputation MSP Settings Experience Yahoo Advertising Retail Data Theft Updates Content Filter Licensing WannaCry Server 2008 Students intranet Running Cable Data storage HBO Ali Rowghani Webinar Video Games Conferencing Computing Microsoft Word Monitoring Trending Mobile Virtual Reality Unified Communications Administration Microsoft Excel IT budget Scam Chromecast Remote Monitoring Analysis Music IT solutions Gifts Professional Services Maintenance server installation dvd "cannot install required files" Financial Colocation File Sharing Employer Employee Relationship App store IT Management Analytics stock Windows 10s Hard Drives Financial Technology Travel Device Security Keyboard Files Nanotechnology Instant Messaging Worker Commute Lithium-ion battery Storage Identities Computer Accessories Administrator Credit Cards Mobile Device WIndows Server 2008 tweet Hard Disk Drive Printing Tablets Root Cause Analysis Managing Stress Access calculator Relocation IoT FAQ Identity Books Twitter Scalability NFL Spyware Hiring/Firing Augmented Reality control Business Intelligence Touchscreen Lifestyle Language PDF Charger Data Privacy Outlook WSJ How To CrashOverride Emergency Cache Worker Monitors Thank You Congratulations

Mobile? Grab this Article!

QR-Code dieser Seite

Recent Comments

Anna Jackson 5 SEO Tools To Get a Google-Eye View of Your Website
15 September 2017
Hello Randall! I was doing very important work but due to your subject I felt better to stay at you...
David Miller Not all project-management tools are right for all businesses
25 August 2017
All the points depicted by you in this blog is v.apt. I love the title of this blog because it says ...