• Home
  • Tools dropdown img
    • Spreadsheet Charts

      • ChartExpo for Google Sheets
      • ChartExpo for Microsoft Excel
    • Power BI Charts

      • Power BI Custom Visuals by ChartExpo
    • Word Cloud

  • Charts dropdown img
    • Chart Category

      • Bar Charts
      • Circle Graphs
      • Column Charts
      • Combo Charts
      • Comparison Charts
      • Line Graphs
      • PPC Charts
      • Sentiment Analysis Charts
      • Survey Charts
    • Chart Type

      • Box and Whisker Plot
      • Clustered Bar Chart
      • Clustered Column Chart
      • Comparison Bar Chart
      • Control Chart
      • CSAT Score Bar Chart
      • CSAT Score Survey Chart
      • Dot Plot Chart
      • Double Bar Graph
      • Funnel Chart
      • Gauge Chart
      • Likert Scale Chart
      • Matrix Chart
      • Multi Axis Line Chart
      • Overlapping Bar Chart
      • Pareto Chart
      • Radar Chart
      • Radial Bar Chart
      • Sankey Diagram
      • Scatter Plot Chart
      • Slope Chart
      • Sunburst Chart
      • Tornado Chart
      • Waterfall Chart
      • Word Cloud
    • Google Sheets
      Microsoft Excel
  • Services
  • Pricing
  • Blog
  • Support dropdown img
      • Gallery
      • Videos
      • Contact Us
      • FAQs
      • Resources
    • Accessible Support

      for Your Journey

Categories
All Data Visualizations Data Analytics Data Stories
Add-ons
  • Google Sheets
  • Microsoft Excel
  • Power BI
All Data Visualizations Data Analytics
Data Stories
  • Healthcare
Add-ons
  • Google Sheets
  • Microsoft Excel
  • Power BI

We use cookies

This website uses cookies to provide better user experience and user's session management.
By continuing visiting this website you consent the use of these cookies.

Ok

ChartExpo Survey



Home > Blog > Data Visualization > Add-ons > Microsoft Excel >

How to Create a Chart in Excel?

Creating charts is one of the most reliable ways of visualizing data. With the right choice of charts and graphs, you would represent your data in an easy-to-digest format. The thing is, most people are somewhat confused when it comes to making a graph in Excel, and if you’re like most people, you’re figuring out how to create a chart in Excel.

how to create a chart in excel

Well, the process is relatively straightforward — and you can accomplish it using Excel 365, Excel 2016, Excel for mac, or Excel 2013. Simply put, you can make charts in Excel using any Excel version. And if you want to take it a step further, you get to use the Excel ChartExpo add-in to professionally create charts for your audience.

Before diving into the ways of creating a chart in Excel, you’ve got to get a good grasp of what graphs and charts are — here’s a brief overview of these data visualization tools.

Table of Content:

  1. What are Charts and Graphs?
  2. Types of Chart and Graph in Excel 
  3. How to Make Charts in Excel 365, Excel 2016, and Excel 2013?
  4. How to Make Graphs in Excel 365, Excel 2016, and Excel 2013?
  5. Wrap Up

What are Charts and Graphs in Excel?

Charts and graphs are data visualization tools that help elevate your data. By using these tools to represent your data, you would present the data to your audience in an easy-to-digest format. Although these terms are used interchangeably, they are somewhat different — and can serve different purposes.

If you are looking for the basic way of representing data, then you’re better off with graphs. With graphs, you get to showcase data points over a period. The time frame could be seconds, minutes, hours, days, or weekly. It’s worthy to note that the time frame is largely determined by the analysts — and the type of data to be measured.

On the other hand, charts are quite complex, and they are used for comparing data pieces relative to one another. Since charts take different shapes rather than the regular x- and y-axis, these data visuals are considered more visually appealing than graphs.

As an analyst, you could use charts and graphs to present your data to management, team members, stakeholders, or your clients. This way, they get to peek into the progress of your project and possibly draw insights from your results.

Moving on, charts and graphs help in representing the various types of quantitative data. Aside from the various data sets it can represent, these visual tools help you to save time and eliminate the tedious work that goes into using spreadsheets.

Creating graphs and charts using Excel ChartExpo add-in is easy, and if you’re looking for a reliable way of storing data, you can also do that using Excel.

Types of Chart and Graph in Excel ChartExpo Add-in

The Excel ChartExpo add-in offers a plethora of chart and graph types. The rules to make charts in Excel are not set in stone — and you get to use them for Excel 2016, Excel 2013, Excel for mac, or any other Excel type.

Yes, multiple charts (or graphs) may work for a particular data set. But if you want to get the most out of your data story, you’ve got to choose the right chart that best fits the data you want to represent.

With over fifty charts (and graphs) in the Excel ChartExpo add-in, here are five main categories of graphs or charts.

1. Column Charts:

These are arguably the most commonly used charts. The Column Chart is usually used for comparing data sets. The ChartExpo Excel add-in offers different Column Chart types like Pareto Column Chart, Column Chart, Grouped Column Chart, Stacked Column Chart, and the Dual Axis Grouped Column Chart etc.

pareto column chart on how to create a chart in excel

Pareto Column Chart

column chart on how to create a chart in excel

Column Chart

grouped column chart on how to create a chart in excel

Grouped Column Chart

stacked column chart on how to create a chart in excel

Stacked Column Chart

dual axis grouped column chart on how to create a chart in excel

Dual-axis grouped Column Chart

2. Pie Charts:

Pie charts are used for comparing the percentages of a whole. During data visualization, the whole could be the sum of all values in your data set. Pieces of the pie are used in representing the value on each portion of the pie.

pie chart on how to create a chart in excel

3. Bar Charts:

The bar chart is quite similar to the Column Chart. Unlike the Column Chart, the bar chart is created using horizontal bars. Most times, bar charts are used interchangeably with Column Charts — but some analysts are keen on using Column Charts, especially when they work with negative values. Since the vertical bars appear on the y-axis, it makes it easier to visualize negative values vertically.

Here are some types of bar charts you would find in the ChartExpo Excel add-in — Pareto Bar Chart, Comparison Bar Chart, Grouped Bar Chart, Double Bar Graph, Bar Chart, Stacked Bar Chart, Dual Axis Grouped Bar Chart, Performance Bar Chart, and the Double Axis Line and Bar Chart.

pareto bar chart on how to create a chart in excel

Pareto Bar Chart

comparison bar chart on how to create a chart in excel

Comparison Bar Chart

grouped bar chart on how to create a chart in excel

Grouped Bar Chart

double bar graph on how to create a chart in excel

Double Bar Graph

bar chart on how to create a chart in excel

Bar Chart

stacked bar chart on how to create a chart in excel

Stacked Bar Chart

dual axis grouped bar chart on how to create a chart in excel

Dual-axis Grouped Bar Chart

Performance bar chart on how to create a chart in excel

Performance Bar Chart

double axis line and bar chart on how to create a chart in excel

Double Axis Line and Bar Chart

4. Line Charts:

Unlike other visual tools that are used for representing static data sets, the Line Chart is usually used to show trends over time. The data points in a Line Chart are connected using lines. This way, you get to see how the values of the data set to increase (or decrease) over time.

There are various Line Chart types in the ChartExpo Excel add-in. You would most likely come across Line Chart types like Multi Series Line Chart, Line Chart, Area Line Chart, SparkLine Chart, Multi-Series SparkLine Chart, Dual Axis Line Chart, and Vertical Axis Line Chart.

multi series line chart on how to create a chart in excel

Multi-series Line Chart

line chart on how to create a chart in excel

Line Chart

area line chart on how to create a chart in excel

Area Line Chart

sparkline chart on how to create a chart in excel

Sparkline Chart

multi series sparkline chart on how to create a chart in excel

Multi-series Sparkline Chart

dual axis line chart on how to create a chart in excel

Dual-axis Line Chart

multi axis line chart on how to create a chart in excel

Multi-Axis Line Chart

Other categories of charts you would come across include area charts, Sankey Charts, Scale Charts, Radar Charts, Gauge Charts, Sentiment Charts, and lots more.

Creating any of these charts (or graphs) in Excel follows a similar pattern — and here is how to do just that.

How to Make Charts in Excel 365, Excel 2016, and Excel 2013?

To create charts in Excel, you’ve got to have the Excel desktop app and the ChartExpo for Excel add-in. After installing the add-in, you’ve got to gather your data and insert it in the worksheet.

Let’s say you manage an electronic business, and you want to track your sales using a pie chart — the first step is to gather your data set and insert it in the worksheet as shown below. After inserting the data set, highlight it.

Item Sold No. of units
Laptops 200
Television 100
Mouse 600
Phone 750
Keyboard 300

Next, click on the Insert button on the top left corner of your screen, navigate to the My Add-ins option, and click on it.

insert chartexpo in excel
  • Select ChartExpo and click the Insert button to get started with ChartExpo.
open chartexpo in excel
  • Once ChartExpo is loaded, you will see a list of charts.
list of charts in-excel

For this illustration, we would be creating a Pie Chart. To create a pie chart, highlight your data on the spreadsheet and click on the Pie Chart.

search chart in excel
  • Select your data and click the Create Chart from Selection button.
create chart in excel
  • At this point, you can customize your visuals to fit your needs. Let’s start by editing the elements of the chart. To do that, click on the Edit Chart option.
edit chart in excel
  • Here, you get to edit elements like the Chart Header and the Chart Footer.
edit chart header in excel
  • By clicking on any of the elements, you get to customize any of the microelements.
  • Let’s say you click on the Chart Header Properties, you would get to edit things like the chart header and other elements.
edit chart header properties in excel
  • After editing the Chart Header to electronics store sales analysis, you would have to click on Apply.
apply chart settings in excel
  • Once you are done with all the editing click on Save Changes.
save chart in excel
  • There is an option of exporting your charts via Windows and Mac. To do that, click on the Export Chart option and follow the directions given.
export chart in excel

You can create other Excel chart types following the same guidelines — all you need to do is choose your preferred chart type, customize it to fit your need, and export using any of the recommended channels.

From the chart, you would see that the products with the highest sales volume are phones and mouse respectively. However, the product with the least volume of sales is the television.

Moving on, here is how to make graphs in Excel.

How to Make Graphs in Excel 365, Excel 2016, and Excel 2013?

Making graphs in Excel is somewhat straightforward — you’ve got to install the ChartExpo Excel add-in, gather your data, and insert it into the spreadsheet.

Let’s say you’re the sales manager of your organization, and you want to compare the sales of five different products in four years, here is what you need to do.

Gather your data and insert it into the spreadsheet.

Products Q1 Q2 Q3 Q4
Product A 20000 60000 72000 93000
Product B 85000 120000 50000 40000
Product C 62000 35000 80000 100000
Product D 40000 70000 50000 35000
Product E 15000 25000 62000 81000

For this illustration, a Grouped Column Chart will be created to showcase the sales of the various products over time. After clicking on the add-in option, a list of graphs will be displayed on your screen — choose Grouped Column Chart.

search chart in excel
  • Select your data and click the Create Chart from Selection button.
create chart in excel
  • Check out the final chart created on Company Sales Perfomance.
grouped coloumn graph in excel on how to create a chart in excel

From the image above, you would see some options — you can opt to Edit Chart or Export Chart. If you click on the Edit Chart option, you would get the chance of customizing the elements in your graph. But if you want to export your data visual, then you’ve got to click on the Export Chart option.

FAQs:

What tools can you use to make charts in Excel?

To create charts in Excel, install the ChartExpo Excel add-in. ChartExpo is a visualization tool that would help you create compelling data visuals in no time. By merely inserting your data into the spreadsheet, you get to navigate and choose your most preferred visualization tool. After that, you would generate catchy charts (or graphs) in no time.

The best part, no coding skill is required.

How can you create a bar chart in Excel?

Creating bar charts is somewhat straightforward. First, install the ChartExpo Excel add-in. Next, insert your data into the spreadsheet.

Click on the insert icon at the top left corner of your screen. Next, click on the add-in icon and click ChartExpo.

On the next screen that displays, you’ve got to carefully search for the bar chart and click on it.

What is a chart (or graph) in Microsoft Excel?

A chart, also known as a graph in Microsoft Excel is a powerful tool that helps in the creation of compelling data visuals. If you’re looking for a reliable way of representing your data, you can opt for various chart (or graph) formats like a bar, line, column, area, pie, doughnut, surface, scatter, or radar charts. Before choosing a chart format, you’ve got to be sure that it will accurately represent your data.

The best part, you can use the ChartExpo Excel add-in to create these charts — and you can do that without any coding skills.

Wrap Up:

By now, you’ve learned how to create charts in Excel. You don’t need any coding skills to get it done. If you’ve got a good grasp of Microsoft Excel and its workings, you can easily create several charts without a sweat.

ChartExpo is one of the best data visualization tools out there — and you can use the tool for the creation of charts (and graphs) in Excel.

Regardless of your level of expertise, all you’ve got to do is install the add-in and kick start your journey in the world of data visuals.

With great visuals, you get to translate complex data into an easy-to-understand format. Whether you’re looking to present data to your customers, stakeholders, or your team members, compelling data visuals created using ChartExpo will help you get it done.

Now you’ve got a good grasp of the various charts in Excel, what chart (or graph) will you be using to create your next data visual?

How much did you enjoy this article?

chartexpo ad
chartexpo ad
chartexpo ad
chartexpo ad
119673

Related articles

next previous
Microsoft Excel9 min read

Visualizing Data Using Customer Satisfaction Survey Software

Discover the best customer satisfaction survey software. You’ll also learn how to visualize and analyze survey results in Excel for actionable insights.

Microsoft Excel9 min read

How to Analyze Customer Experience Measures in Excel?

Learn how to measure and analyze customer experience using Excel. Discover the six key customer experience measures and how to create effective charts.

Microsoft Excel9 min read

How to Analyze Competitive Analysis Research Data in Excel?

Click here to learn how to effectively analyze competitive analysis research data in Excel with the best charts and visualization techniques.

Microsoft Excel9 min read

Mastering the Art of Analyzing and Interpreting Data in Excel

Learn the essential techniques for analyzing and interpreting data in Excel. We’ll show you how to create charts, interpret data, and unlock insights.

Microsoft Excel9 min read

How to Analyze Market Research Survey Data in Excel?

Learn how to conduct and analyze a market research survey. This guide also has the best market research questions to ask in your next survey.

ChartExpo logo

Turn Data into Visual
Stories

CHARTEXPO

  • Home
  • Gallery
  • Videos
  • Services
  • Pricing
  • Contact us
  • FAQs
  • Privacy policy
  • Terms of Service
  • Sitemap

TOOLS

  • ChartExpo for Google Sheets
  • ChartExpo for Microsoft Excel
  • Power BI Custom Visuals by ChartExpo
  • Word Cloud

CATEGORIES

  • Bar Charts
  • Circle Graphs
  • Column Charts
  • Combo Charts
  • Comparison Charts
  • Line Graphs
  • PPC Charts
  • Sentiment Analysis Charts
  • Survey Charts

TOP CHARTS

  • Sankey Diagram
  • Likert Scale Chart
  • Comparison Bar Chart
  • Pareto Chart
  • Funnel Chart
  • Gauge Chart
  • Radar Chart
  • Radial Bar Chart
  • Sunburst Chart
  • see more
  • Scatter Plot Chart
  • CSAT Score Bar Chart
  • CSAT Score Survey Chart
  • Dot Plot Chart
  • Double Bar Graph
  • Matrix Chart
  • Multi Axis Line Chart
  • Overlapping Bar Chart
  • Control Chart
  • Slope Chart
  • Clustered Bar Chart
  • Clustered Column Chart
  • Box and Whisker Plot
  • Tornado Chart
  • Waterfall Chart
  • Word Cloud
  • see less

RESOURCES

  • Blog
  • Resources
  • YouTube
SIGN UP FOR UPDATES

We wouldn't dream of spamming you or selling your info.

© 2023 ChartExpo, all rights reserved.