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
      • Leading Change and Organizational Renewal
      • Dynamic Teaming
      • Transforming Customer Experiences
    • Credential of Leadership, Impact, and Management in Business (CLIMB)
    • Credential of Digital Innovation and Strategy
    • Entrepreneurship & Innovation
      • Entrepreneurship Essentials
      • Disruptive Strategy
      • Negotiation Mastery
      • Design Thinking and Innovation
      • Launching Tech Ventures
      • Winning with Digital Platforms
      • Leading Change and Organizational Renewal
      • Entrepreneurial Marketing
      • Transforming Customer Experiences
    • Strategy
      • Strategy Execution
      • Business Strategy
      • Economics for Managers
      • Disruptive Strategy
      • Global Business
      • Sustainable Business Strategy
    • Marketing
      • Digital Marketing Strategy
      • Creating Brand Value
      • Entrepreneurial Marketing
    • Digital Transformation
      • Winning with Digital Platforms
      • AI Essentials for Business
    • Finance & Accounting
      • Financial Accounting
      • Leading with Finance
      • Alternative Investments
      • Sustainable Investing
      • Strategic Financial Analysis
    • Business in Society
      • Sustainable Business Strategy
      • Global Business
      • Sustainable Investing
      • Power and Influence for Positive Impact
      • Leadership, Ethics, and Corporate Accountability
      • Business and Climate Change
    • 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
    • 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
      • Learner on computer exploring HBS Online business lessons
        Sample Business Lessons and E-Books

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

      • HBS Online Parlor Room podcast logo
        Podcast

        The Parlor Room: Where business concepts come to life. Listen now on your favorite podcast platform.

    • 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
      • Enroll Now
    Login
    My Courses
    Access your courses and engage with your peers
    My Account
    Manage your account, enrollment, 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
    • Credential of Leadership, Impact, and Management in Business (CLIMB)
    • Credential of Digital Innovation and Strategy
    • Entrepreneurship & Innovation
    • Strategy
    • Marketing
    • Digital Transformation
    • Finance & Accounting
    • Business in Society
    • For Organizations
    • Insights
    • More Info
    • About
    • Support Portal
    • Media Coverage
    • Founding Donors
    • Leadership Team
    • Careers
    • My Courses
    • My Account
    • Enroll 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
    • Digital Transformation
    • Earning Your MBA
    • Entrepreneurship & Innovation
    • Finance
    • For Organizations
    • Leadership
    • Management
    • Marketing
    • Negotiation
    • News & Events
    • Productivity
    • Staff Spotlight
    • Strategy
    • Student Profiles
    • Technology
    • Work-Life Balance

    Courses

    Courses

    • AI Essentials for Business
    • Alternative Investments
    • Business Analytics
    • Business Strategy
    • Business and Climate Change
    • CLIMB
    • CORe
    • Creating Brand Value
    • Credential of Digital Innovation and Strategy
    • Design Thinking and Innovation
    • Digital Marketing Strategy
    • Disruptive Strategy
    • Dynamic Teaming
    • Economics for Managers
    • Entrepreneurial Marketing
    • Entrepreneurship Essentials
    • Financial Accounting
    • Global Business
    • Launching Tech Ventures
    • Leadership Principles
    • Leadership, Ethics, and Corporate Accountability
    • Leading Change and Organizational Renewal
    • Leading with Finance
    • Management Essentials
    • Negotiation Mastery
    • Organizational Leadership
    • Power and Influence for Positive Impact
    • Strategic Financial Analysis
    • Strategy Execution
    • Sustainable Business Strategy
    • Sustainable Investing
    • Transforming Customer Experiences
    • Winning with Digital Platforms
    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
    • Digital Transformation
    • Earning Your MBA
    • Entrepreneurship & Innovation
    • Finance
    • For Organizations
    • Leadership
    • Management
    • Marketing
    • Negotiation
    • News & Events
    • Productivity
    • Staff Spotlight
    • Strategy
    • Student Profiles
    • Technology
    • Work-Life Balance

    Courses

    Courses

    • AI Essentials for Business
    • Alternative Investments
    • Business Analytics
    • Business Strategy
    • Business and Climate Change
    • CLIMB
    • CORe
    • Creating Brand Value
    • Credential of Digital Innovation and Strategy
    • Design Thinking and Innovation
    • Digital Marketing Strategy
    • Disruptive Strategy
    • Dynamic Teaming
    • Economics for Managers
    • Entrepreneurial Marketing
    • Entrepreneurship Essentials
    • Financial Accounting
    • Global Business
    • Launching Tech Ventures
    • Leadership Principles
    • Leadership, Ethics, and Corporate Accountability
    • Leading Change and Organizational Renewal
    • Leading with Finance
    • Management Essentials
    • Negotiation Mastery
    • Organizational Leadership
    • Power and Influence for Positive Impact
    • Strategic Financial Analysis
    • Strategy Execution
    • Sustainable Business Strategy
    • Sustainable Investing
    • Transforming Customer Experiences
    • Winning with Digital Platforms
    Subscribe to the Blog
    *
    Please complete this required field.
    Email must be formatted correctly.
    Please complete all required fields.
    RSS feed

    Creating Data Visualizations in Excel: What to Keep in Mind

    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 and 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. Coursework must be completed in English.

    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?

    +–

    Certificate Programs

    HBS Online welcomes committed learners wherever they are—in the world and their careers—irrespective of their professional experience or academic background. To extend the reach of HBS Online, we no longer require an application for our certificate programs. (Applications are still required for our credential programs: CORe and CLIMB.) You can now immediately enroll and start taking the next step in your career.

    All programs require the completion of a brief online enrollment form before payment. If you are new to HBS Online, you will be required to set up an account before enrolling in the program of your choice.

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

    Updates to your enrollment status will be shown on your account page. HBS Online does not use race, gender, ethnicity, or any protected class as criteria for enrollment for any HBS Online program.

    Credential Programs

    HBS Online's CORe and CLIMB programs require the completion of a brief application. The applications vary slightly, 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 participants must be at least 18 years of age, proficient in English, and committed to learning and engaging with fellow participants throughout the program.

    Updates to your application and enrollment status will be shown on your account page. We confirm enrollment eligibility within one week of your application for CORe and three weeks for CLIMB. HBS Online does not use race, gender, ethnicity, or any protected class as criteria for admissions for any HBS Online program.

    Does Harvard Business School Online offer an online MBA?

    +–

    No, Harvard Business School Online offers business certificate programs.

    What are my payment options?

    +–

    HBS Online offers a variety of payment methods to provide flexibility, including:

    • Credit and debit cards (Visa, MasterCard, Discover, and AMEX)
    • PayPal
    • Wire transfers
    • Western Union
    • Bank loans (When available)

    You may split your payment across two credit card transactions or send a payment link to another individual to complete payment on your behalf. A minimum payment of $350 is required for the first transaction.

    Some learners may also 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 more information.

    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
    • Marketing
    • Finance & Accounting
    • Business & Society
    • Digital Transformation

    Quick Links

    • FAQs
    • Contact Us
    • Request Info
    • Enroll 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