• 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 Survey Bar Chart
      • CSAT 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
  • Contact us
  • Blog
  • Support dropdown img
      • Gallery
      • Videos
      • Contact us
      • FAQs
      • Resources
    • Please feel free to contact us

      atsupport@chartexpo.com

Categories
All Data Visualizations Data Analytics Surveys
Add-ons/
  • Google Sheets
  • Microsoft Excel
  • Power BI
All Data Visualizations Data Analytics Surveys
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 > Microsoft Excel

How to Make a Bar Chart in Excel with One Column of Data?

A Bar Chart is best suited in displaying comparison insights, especially if you’re dealing with one column of data.

how to make a bar chart in excel with on column of data

Why?

Besides, the visualization is arguably among the most straightforward charts to decode. You can use this chart to create persuasive and irresistible data stories.

You require the best visualization tool to plot easy-to-interpret and visually-stunning Bar Graphs. Yes, you need a tool that’s easy to use and affordable.

Excel seems to be the logical choice for many. However, the spreadsheet application has very basic Bar Graphs, which requires a ton of work and time in editing.

So, what’s the solution?

There’s a particular add-in you can easily download and install in your Excel. The add-in (mentioned above) generates a ready-to-use Bar Chart in Excel with one column of data.

Table of Content:

  1. What is a Bar Chart and When to Use it?
  2. How to Make a Bar Chart in Excel with One Column of Data? Easy Steps
  3. Wrap Up

What is a Bar Chart and When to Use it?

A Bar Graph is a chart that displays insights using rectangular bars or columns.

what is a bar chart

Visualization Source: ChartExpo

Bar charts come in multiple variants, namely:

  • Vertical Column Chart
  • Horizontal Bar Chart
  • Comparative Bars Chart
  • Stacked Bars Chart

The visualization design was first used by Nelvin Ks (1759-1824) to display insights into Scotland’s imports between 1780 and 1781.

If your goal is to display the composition and comparison of key variables in your data, your go-to chart should be a side-by-side Bar Chart in Excel, where you can easily compare multiple columns of data.”

Keep reading because we’ll cover the following in the coming section: How to make a Bar Chart in Excel with one column of data?

Excel is one of the most used tools for visualizing data because it’s easy to use. 

However, a ready-made Bar Chart in Excel with one column of data does not exist in Excel’s chart library. But this does not mean you should ditch this freemium data visualization tool.

Did you know you can supercharge your Excel with add-ins to access visually stunning and ready-to-go Bar Graphs?

Yes, you can increase the functionality of your tool and access a ready-made Clustered Stacked Bar Graph in Excel with one column of data for your data stories.

The add-on we recommend you to use is ChartExpo.

So, what is ChartExpo?

We recommend this tool (ChartExpo) because it’s super easy to use.

You don’t need to take programming night classes to extract insights from your data. ChartExpo is more of a ‘drag-and-drop tool,’ which means you’ll only need to scroll your mouse and fill in respective metrics and dimensions in your data.

The Bar Chart in Excel with one column of data Excel generator comes with a 7-day free trial period.

More so, the tool produces charts that are incredibly easy to read and interpret. And it allows you to save charts in the world’s most recognized formats, namely PNG and JPG.

How to make a Bar Chart in Excel with one column of data should never consume your valuable time. Keep reading to discover tips that can help you hasten the time-intensive process, especially when you need to make a graph from a table.

How to Make a Bar Chart in Excel with One Column of Data? Easy Steps

Example

In this section, we’ll use the Bar Chart in ChartExpo to display insights into the table below.

Product Number of Orders
Headphones 70
Laptops 60
Mobile 95
Mic 45
Speakers 80
Monitors 50
Desktop PCs 65

To install the ChartExpo add-in into your Excel, click this link.

  • Open your Excel and paste the table above.
  • Click the My Apps button and then click the ChartExpo for Excel, as shown below.
open chartexpo in-excel
  • Click the Search Box and type “Bar Chart.”
  • Once the Bar Chart pops up, click on its icon to get started, as shown below.
search bar chart in excel
  • Select the sheet holding your data and click the Create Chart from Selection.
create bar chart in excel

How to Edit a Bar Chart in Excel with One Column of Data?

edit bar chart in excel
  • Click the Edit Chart button, as shown above.
  • Once the Chart Header Properties window shows, click the Line 1 box and fill in your title.
edit bar chart header properties in excel
  • Toggle the small switch below Line 2 to the right side, as shown above.
  • Save your changes by clicking the Apply.

How to make a Bar Chart in Excel with one column of data should never stress you. Use ChartExpo.

How to Edit the Bar Chart’s Footer Properties?

  • Click the pen-like icons called the Chart Footer.
  • Once the Chart Footer Properties window shows, click the Line 1 box and fill in your footer information.
edit bar chart header left properties in excel
  • Toggle the small switch below Line 2 to the right side, as shown above.
  • Save your changes by clicking the Apply.

How to Edit the Bar Chart’s Header Left Properties?

  • Click the pen-like icons called the Chart Label Left.
  • Once the Chart Header Left Properties window shows, click the Line 1 box and fill in your chart left label information.
  • Toggle the small switch below Line 1 to the right side, as shown above.
  • Save your changes by clicking the Apply button.

How to make a Bar Chart in Excel with one column of data should never overwhelm you with complex steps. Use ChartExpo.

save bar chart in excel
  • Your final Bar Chart will have detailed legend information on x and y-axes.
  • Protect the changes made by clicking the Save Change button, as shown above.
  • Check out the final chart below.
bar chart in excel with one column of data

FAQs:

What are the uses of Bar Charts in the business world?

Bar Graphs are charts that display insights using rectangular bars or columns.

Businesses like yours can use the visualization design to display comparison insights into key business metrics, such as profits versus gross revenue, costs versus gross income, and profit vs. costs.

What are the main types of Bar Charts?

A Bar Graph is a visualization design you can leverage to display insights using rectangular bars or columns. Also, you can use the chart to display one-to-many relationships in data.

The chart comes in multiple variants, namely:

  • Vertical Column Chart
  • Horizontal Bar Chart
  • Comparative Bars Chart
  • Stacked Bars Chart

Wrap Up

A Bar Chart is best suited to displaying comparison insights, especially if you’re dealing with one column of data.

Why?

Besides, the visualization is arguably among the most detailed charts to decode. You can use this chart to create compelling and irresistible data stories.

You require the best visualization tool to plot easy-to-interpret and visually stunning Bar Graphs.  Yes, it would help if you had an easy-to-use and affordable tool.

Excel, one of the popular tools for visualizing data, comes with very basic Bar Charts, which require a ton of work and time in editing.

How to make a Bar Chart in Excel with one column of data should never overwhelm you with complex steps.

We recommend you try ChartExpo because it’s one of the most trusted add-ins. Besides, it has a super-friendly user interface for everyone, irrespective of their computer skills.

Create simple, ready-made, and easy-to-interpret Bar Charts today without breaking a sweat.

How much did you enjoy this article?

ExcelAd1
Start Free Trial!
118627

Related articles

next previous
Microsoft Excel11 min read

Succession Planning Template for Long-Term Success

Succession Planning Templates help businesses prepare for leadership changes. Learn to create, analyze, and use them for seamless transitions and growth.

Microsoft Excel10 min read

Grant Tracking Spreadsheet: Insights Made Easy

A Grant Tracker Spreadsheet helps track funding, deadlines, and expenses in Excel. Learn to use grant tracking templates, analyze data, and stay organized.

Microsoft Excel10 min read

What is Excel Software Used for: A Complete Guide

What is Excel software used for? It organizes, analyzes, and manages data. Explore its workplace applications, benefits, and top tips for efficiency and more.

Microsoft Excel12 min read

Artificial Intelligence in Excel for Clear Insights

Discover how AI elevates Excel, from automation to advanced data analysis. This blog covers benefits, limitations, and examples to enhance your productivity.

Microsoft Excel8 min read

Excel Task Tracker Template for Smarter Task Insights

Task tracker template in Excel organizes tasks, tracks deadlines, and boosts efficiency. Learn its benefits, and explore expert tips to simplify task management.

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 Survey Bar Chart
  • CSAT 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.

© 2025 ChartExpo, all rights reserved.