Skip to Main Content
HBS Online
  • Courses
    Open Courses Mega Menu
    • Business Essentials
      • Credential of Readiness (CORe)
      • Business Analytics
      • Economics for Managers
      • Financial Accounting
    • Leadership & Management
      • Leadership Principles
      • Management Essentials
      • Negotiation Mastery
      • Organizational Leadership
      • Strategy Execution
      • Power and Influence for Positive Impact
      • Leadership, Ethics, and Corporate Accountability
    • Entrepreneurship & Innovation
      • Entrepreneurship Essentials
      • Disruptive Strategy
      • Negotiation Mastery
      • Design Thinking and Innovation
      • Launching Tech Ventures
    • Strategy
      • Strategy Execution
      • Business Strategy
      • Economics for Managers
      • Disruptive Strategy
      • Global Business
      • Sustainable Business Strategy
    • Finance & Accounting
      • Financial Accounting
      • Leading with Finance
      • Alternative Investments
      • Sustainable Investing
    • Business in Society
      • Sustainable Business Strategy
      • Global Business
      • Sustainable Investing
      • Power and Influence for Positive Impact
      • Leadership, Ethics, and Corporate Accountability
    • All Courses
  • For Organizations
    Open For Organizations Mega Menu
    • Corporate Learning
      Help your employees master essential business concepts, improve effectiveness, and expand leadership capabilities.
    • Academic Solutions
      Integrate HBS Online courses into your curriculum to support programs and create unique educational opportunities.
    • Need Help?
      • Frequently Asked Questions
      • Contact Us
    • Black, Latinx, and underrepresented minority professionals
      Pathways to Business

      Stories designed to inspire future business leaders.

  • Insights
    Open Insights Mega Menu
    • Business Insights Blog
      • Career Development
      • Communication
      • Decision-Making
      • Earning Your MBA
      • Entrepreneurship & Innovation
      • Finance
      • Leadership
      • Management
      • Negotiation
      • Strategy
    • All Topics
    • Sample Business Lessons and E-Books

      Gain new insights and knowledge from leading faculty and industry experts.

    • Free Guide

      Learn how to formulate a successful business strategy.

  • More Info
    Open More Info Mega Menu
    • Learning Experience
      Master real-world business skills with our immersive platform and engaged community.
    • Certificates, Credentials, & Credits
      Learn how completing courses can boost your resume and move your career forward.
    • Learning Tracks
      Take your career to the next level with this specialization.
    • Financing & Policies
      • Employer Reimbursement
      • Payment & Financial Aid
      • Policies
    • Connect
      • Student Stories
      • Community
    • Need Help?
      • Frequently Asked Questions
      • Request Information
      • Support Portal
    • Apply Now
Login
My Courses
Access your courses and engage with your peers
My Account
Manage your account, applications, and payments.
HBS Home
  • About HBS
  • Academic Programs
  • Alumni
  • Faculty & Research
  • Baker Library
  • Giving
  • Harvard Business Review
  • Initiatives
  • News
  • Recruit
  • Map / Directions
HBS Online
  • Courses
  • Business Essentials
  • Leadership & Management
  • Entrepreneurship & Innovation
  • Strategy
  • Finance & Accounting
  • Business in Society
  • For Organizations
  • Insights
  • More Info
  • About
  • Support Portal
  • Media Coverage
  • Founding Donors
  • Leadership Team
  • Careers
  • My Courses
  • My Account
  • Apply Now
  • …→
  • Harvard Business School→
  • HBS Online→
  • Business Insights→

Business Insights

Harvard Business School Online's Business Insights Blog provides the career insights you need to achieve your goals and gain confidence in your business skills.

 
Filter Results Arrow Down Arrow Up

Topics

Topics

  • Accounting
  • Analytics
  • Business Essentials
  • Business in Society
  • Career Development
  • Communication
  • Community
  • ConneXt
  • Decision-Making
  • Earning Your MBA
  • Entrepreneurship & Innovation
  • Finance
  • Leadership
  • Management
  • Marketing
  • Negotiation
  • News & Events
  • Productivity
  • Staff Spotlight
  • Strategy
  • Student Profiles
  • Technology
  • Work-Life Balance

Courses

Courses

  • Alternative Investments
  • Business Analytics
  • Business Strategy
  • CORe
  • Design Thinking and Innovation
  • Disruptive Strategy
  • Economics for Managers
  • Entrepreneurship Essentials
  • Financial Accounting
  • Global Business
  • Launching Tech Ventures
  • Leadership Principles
  • Leadership, Ethics, and Corporate Accountability
  • Leading with Finance
  • Management Essentials
  • Negotiation Mastery
  • Organizational Leadership
  • Power and Influence for Positive Impact
  • Strategy Execution
  • Sustainable Business Strategy
  • Sustainable Investing
Subscribe to the Blog
*
Please complete this required field.
Email must be formatted correctly.
Please complete all required fields.
RSS feed

Filters

Topics

Topics

  • Accounting
  • Analytics
  • Business Essentials
  • Business in Society
  • Career Development
  • Communication
  • Community
  • ConneXt
  • Decision-Making
  • Earning Your MBA
  • Entrepreneurship & Innovation
  • Finance
  • Leadership
  • Management
  • Marketing
  • Negotiation
  • News & Events
  • Productivity
  • Staff Spotlight
  • Strategy
  • Student Profiles
  • Technology
  • Work-Life Balance

Courses

Courses

  • Alternative Investments
  • Business Analytics
  • Business Strategy
  • CORe
  • Design Thinking and Innovation
  • Disruptive Strategy
  • Economics for Managers
  • Entrepreneurship Essentials
  • Financial Accounting
  • Global Business
  • Launching Tech Ventures
  • Leadership Principles
  • Leadership, Ethics, and Corporate Accountability
  • Leading with Finance
  • Management Essentials
  • Negotiation Mastery
  • Organizational Leadership
  • Power and Influence for Positive Impact
  • Strategy Execution
  • Sustainable Business Strategy
  • Sustainable Investing
Subscribe to the Blog
*
Please complete this required field.
Email must be formatted correctly.
Please complete all required fields.
RSS feed

What to Keep in Mind When Creating Data Visualizations in Excel

Professional creating data visualizations in Excel
  • 14 Oct 2021
Kelsey Miller Author Contributors
tag
  • Analytics
  • Business Analytics
  • CORe

One of the most valuable and abundant resources businesses have at their disposal is data. With vast amounts of data being generated every minute of every day, the insights gleaned can inform virtually every business decision—often resulting in favorable outcomes.

There are many data visualization tools on the market designed for creating illustrations for business purposes. Fortunately, one of the most popular and easy-to-use options is likely already installed on your computer: Microsoft Excel.

If you don’t have access to Microsoft Excel, consider using free options like Google Sheets for a similar, albeit more limited, experience.

While Excel isn’t visualization software, it’s a versatile, powerful tool for professionals of all levels who want to analyze and illustrate datasets. Here are the types of data visualizations you can create in Excel and the steps involved in doing so, along with some tips to help you along the way.


Free E-Book: A Beginner’s Guide to Data & Analytics

Access your free e-book today.


Types of Data Visualizations in Excel

There are different data visualization techniques you can employ in Excel, depending on the data available to you and the goal you’re trying to achieve, including:

  • Pie charts
  • Bar charts
  • Histograms
  • Area charts
  • Scatter plots

Other visualization techniques can be used to illustrate large or complex data sets. These include:

  • Timelines
  • Gantt charts
  • Heat maps
  • Highlight tables
  • Bullet graphs

More advanced visualizations, such as those that include graphic elements like geographical heat maps, may not be possible to create in Excel or require additional tools.

Related: 6 Data Visualization Examples to Inspire Your Own

How to Create Data Visualizations in Excel

The steps involved in creating data visualizations in Excel depend on the type of graph or chart you choose. For basic visualizations, the process is largely the same. More complex datasets and illustrations may require additional steps.

To craft a data visualization in Excel, start by creating an organized spreadsheet. This should include labels and your final dataset.

Then, highlight the data you wish to include in your visual, including the labels. Select “insert” from the main menu and choose the type of chart or graph you’d like to create. Once you’ve made your selection, the visualization will automatically appear in your spreadsheet.

Right-click on the chart or graph to edit details, such as the title, axes labels, and colors. Doing so will open a pop-up or side panel that includes options to add a legend, adjust the scale, and change font styles and sizes.

Your browser cannot play the provided video file.

Tips for Creating Visualizations in Excel

1. Choose the Right Type of Visualization

To create an effective data visualization, it’s critical to choose the right type of chart or graph. Consider the type of data you’re using, the size of your dataset, and your intended audience.

A mismatch between the type of data being leveraged and the visual used to present it can be detrimental to viewers’ understanding of the information. Whether you’re working with qualitative or quantitative data, for example, impacts how you should display the information.

Your intended audience also influences how simplified or complex your illustration should be. For instance, when presenting to a large audience or high-level stakeholders, it’s helpful to distill your presentation to highlight key trends and insights rather than individual data points.

Business Analytics - Become a data-driven leader. Learn more.

2. Remove Irrelevant or Inaccurate Data

Ultimately, your visualization’s quality is only as good as that of the data you use. For this reason, it’s important to clean data after it’s been collected to remove any irrelevant or inaccurate information. This process is often referred to as data wrangling or data cleaning.

Failure to thoroughly clean data prior to using it can be detrimental to its integrity and lead to inaccurate or misleading data visualizations.

Related: What Is Data Integrity & Why Does It Matter?

3. Provide Context For the Visualization

If necessary, include a key or legend and additional context to help viewers make sense of your illustration.

For example, consider a heatmap that shows the frequency of COVID-19 infections in a location over a specific period. To form a clear understanding of the information being presented, viewers need to know details such as the period being examined, the data source, and what each color means.

This context is important because it helps viewers interpret the information being displayed. Without a key clearly defining the coloring system, for instance, it would be virtually impossible to know what each color indicates, rendering the heatmap useless.

4. Tell A Story

Finally, the key to crafting a compelling visualization is to use data to tell a story. If the data illustrates a trend or supports a hypothesis, your visualization should make that clear. After all, the purpose of visualizations is to present findings in a way that’s easy for viewers to digest and understand.

Telling a story not only makes your visualization more interesting and engaging but also aids in data-driven decision-making. In addition, it helps stakeholders understand the essence of your findings and, in turn, informs their decision-making processes.

A Beginner's Guide to Data & Analytics | Access Your Free E-Book | Download Now

Making Data-Backed Business Decisions

Data visualization is a powerful tool when it comes to addressing business questions and making informed decisions. Learning how to create effective illustrations can empower you to share findings with key stakeholders and other audiences in a manner that’s engaging and easy to understand.

You don’t have to be in an analytics or data science role to take advantage of data visualizations. Professionals of all levels and backgrounds can develop data skills to more effectively communicate within their organizations and make informed decisions.

Are you interested in improving your analytical skills? Learn more about Business Analytics—one of the three courses that comprise CORe—which teaches you how to apply analytical techniques in Excel to solve real business problems.

About the Author

Kelsey Miller is a marketing specialist and contributing writer for Harvard Business School Online.
 
All FAQs

Top FAQs

How are HBS Online courses delivered?

+–

We offer self-paced programs (with weekly deadlines) on the HBS Online course platform.

Our platform features short, highly produced videos of HBS faculty and guest business experts, interactive graphs and exercises, cold calls to keep you engaged, and opportunities to contribute to a vibrant online community.

Are HBS Online programs available in languages other than English?

+–

We expect to offer our courses in additional languages in the future but, at this time, HBS Online can only be provided in English.

All course content is delivered in written English. Closed captioning in English is available for all videos. There are no live interactions during the course that requires the learner to speak English. Written English proficiency should suffice.

Do I need to come to campus to participate in HBS Online programs?

+–

No, all of our programs are 100 percent online, and available to participants regardless of their location.

How do I enroll in a course?

+–

All programs require the completion of a brief application. The applications vary slightly from program to program, but all ask for some personal background information. You can apply for and enroll in programs here. If you are new to HBS Online, you will be required to set up an account before starting an application for the program of your choice.

Our easy online application is free, and no special documentation is required. All applicants must be at least 18 years of age, proficient in English, and committed to learning and engaging with fellow participants throughout the program.

After submitting your application, you should receive an email confirmation from HBS Online. If you do not receive this email, please check your junk email folders and double-check your account to make sure the application was successfully submitted.

Updates to your application and enrollment status will be shown on your Dashboard. We confirm enrollment eligibility within one week of your application.

Does Harvard Business School Online offer an online MBA?

+–

No, Harvard Business School Online offers business certificate programs.

What are my payment options?

+–

We accept payments via credit card, wire transfer, Western Union, and (when available) bank loan. Some candidates may qualify for scholarships or financial aid, which will be credited against the Program Fee once eligibility is determined. Please refer to the Payment & Financial Aid page for further information.

We also allow you to split your payment across 2 separate credit card transactions or send a payment link email to another person on your behalf. If splitting your payment into 2 transactions, a minimum payment of $350 is required for the first transaction.

In all cases, net Program Fees must be paid in full (in US Dollars) to complete registration.

What are the policies for refunds and deferrals?

+–

After enrolling in a program, you may request a withdrawal with refund (minus a $100 nonrefundable enrollment fee) up until 24 hours after the start of your program. Please review the Program Policies page for more details on refunds and deferrals. If your employer has contracted with HBS Online for participation in a program, or if you elect to enroll in the undergraduate credit option of the Credential of Readiness (CORe) program, note that policies for these options may differ.

 

Sign up for News & Announcements


  • • Please complete this required field.
  • • Email must be formatted correctly.
  • • Please complete all required fields.

Subject Areas

  • Business Essentials
  • Leadership & Management
  • Entrepreneurship & Innovation
  • Strategy
  • Finance & Accounting
  • Business & Society

Quick Links

  • FAQs
  • Contact Us
  • Request Info
  • Apply Now
  • Support Portal

About

  • About Us
  • Media Coverage
  • Founding Donors
  • Leadership Team
  • Careers @ HBS Online

Legal

  • Legal
  • Policies
Harvard Business School
Copyright © President & Fellows of Harvard College
  • Site Map
  • Trademark Notice
  • Digital Accessibility