{"id":73942,"date":"2023-07-26T01:00:36","date_gmt":"2023-07-26T05:00:36","guid":{"rendered":"https:\/\/venngage.com\/blog\/?p=73942"},"modified":"2026-03-27T13:27:16","modified_gmt":"2026-03-27T17:27:16","slug":"bar-chart-in-excel","status":"publish","type":"post","link":"https:\/\/venngage.com\/blog\/bar-chart-in-excel\/","title":{"rendered":"How to Make a Bar Chart in Excel: Examples + Free Tool"},"content":{"rendered":"\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"576\" src=\"https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2023\/07\/bar-chart-excel-header-1.png\" alt=\"how to make bar chart in excel\" class=\"wp-image-74413\" srcset=\"https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2023\/07\/bar-chart-excel-header-1.png 1024w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2023\/07\/bar-chart-excel-header-1-300x169.png 300w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2023\/07\/bar-chart-excel-header-1-768x432.png 768w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2023\/07\/bar-chart-excel-header-1-730x411.png 730w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>As someone who\u2019s worked with data across reports, presentations, and marketing materials, I know how valuable a well-designed bar chart can be. It\u2019s one of the simplest and most effective ways to visualize comparisons and trends. <\/p>\n\n\n\n<p>Most people start with Excel or Google Sheets. And while those tools can create functional charts, they often lack design flexibility and take longer to format.<\/p>\n\n\n\n<p>In this guide, I\u2019ll show you how to create a bar chart in Excel, and then introduce you to a faster, more polished option using Venngage\u2019s <a href=\"https:\/\/venngage.com\/features\/bar-graph-maker\" target=\"_blank\" rel=\"noreferrer noopener\">Bar Graph Maker<\/a>, built for better visual impact and ease of use.<\/p>\n\n\n\n<p>Want to skip the setup? Try one of our customizable <a href=\"https:\/\/venngage.com\/templates\/charts\/bar\" target=\"_blank\" rel=\"noreferrer noopener\">bar chart templates<\/a> to save time and present your data beautifully.<\/p>\n\n\n\n<center><a href=\"https:\/\/venngage.com\/features\/bar-graph-maker\" target=\"_blank\" rel=\"noopener\">\n<button class=\"btn-cta\"><b>START CREATING FOR FREE<\/b><\/button><\/a><\/center>&nbsp;\n\n\n\n\n\n<h2 class=\"wp-block-heading\" id=\"basics\">What is a bar chart?<\/h2>\n\n\n\n<p>Before I show you how to create a bar graph in Excel, let&#8217;s understand some basics first.<\/p>\n\n\n\n<p>A bar graph has two axes &#8212; the horizontal X-axis, and the vertical Y-axis. The X-axis showcases categories of data, and the Y-axis is used to present numerical values.<\/p>\n\n\n\n<p>The height of the rectangular bars in a bar graph represents the magnitude of actual data points.<\/p>\n\n\n\n<p>Here&#8217;s an example:<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><a href=\"https:\/\/venngage.com\/templates\/charts\/column-chart--78d5559b-a1f1-4f1a-b586-9d574fb8055e\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" loading=\"lazy\" width=\"640\" height=\"640\" src=\"https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2023\/07\/basic-column-chart.png\" alt=\"Colorful Bar Chart Template\" class=\"wp-image-73955\" srcset=\"https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2023\/07\/basic-column-chart.png 640w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2023\/07\/basic-column-chart-300x300.png 300w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2023\/07\/basic-column-chart-150x150.png 150w\" sizes=\"(max-width: 640px) 100vw, 640px\" \/><\/a><\/figure><\/div>\n\n\n<center><a href=\"https:\/\/venngage.com\/templates\/charts\/column-chart--78d5559b-a1f1-4f1a-b586-9d574fb8055e\" target=\"_blank\" rel=\"noopener\">\n<button class=\"btn-cta\"><b>CREATE THIS BAR CHART<\/b><\/button><\/a><\/center>&nbsp;\n\n\n\n<p>However, bar graphs do not convey information about variance or statistical measure that shows the spread of values or the standard deviation.<\/p>\n\n\n\n<p>If you want to include that information, it\u2019s better to consider box plots instead.<\/p>\n\n\n\n<blockquote class=\"wp-block-quote\">\n<p><strong>For a more comprehensive overview of bar charts, check out this post:<\/strong><\/p>\n\n\n\n<ul>\n<li><a href=\"https:\/\/venngage.com\/blog\/bar-chart\/\" target=\"_blank\" rel=\"noreferrer noopener\">What is a Bar Chart and 20+ Bar Chart Templates<\/a><\/li>\n<\/ul>\n<\/blockquote>\n\n\n\n<p>Other factors you&#8217;ll want to keep in mind include the labels, which provide a description of what each axis represents and gridlines that can be added to aid interpretation.<\/p>\n\n\n\n<p>I&#8217;ve labeled this bar chart with all the information you need to know:<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><a href=\"https:\/\/venngage.com\/templates\/charts\/modern-learn-marketing-bar-chart-4f1fda82-f333-421a-954b-0ba1f9d75037\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"706\" src=\"https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2023\/07\/4e008554-2f85-4bbe-b924-eb1560793ef8-1-1-1024x706.png\" alt=\"labeled bar chart\" class=\"wp-image-74705\" srcset=\"https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2023\/07\/4e008554-2f85-4bbe-b924-eb1560793ef8-1-1-1024x706.png 1024w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2023\/07\/4e008554-2f85-4bbe-b924-eb1560793ef8-1-1-300x207.png 300w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2023\/07\/4e008554-2f85-4bbe-b924-eb1560793ef8-1-1-768x530.png 768w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2023\/07\/4e008554-2f85-4bbe-b924-eb1560793ef8-1-1-1536x1060.png 1536w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2023\/07\/4e008554-2f85-4bbe-b924-eb1560793ef8-1-1-2048x1413.png 2048w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2023\/07\/4e008554-2f85-4bbe-b924-eb1560793ef8-1-1-730x504.png 730w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure><\/div>\n\n\n<center><a href=\"https:\/\/venngage.com\/templates\/charts\/modern-learn-marketing-bar-chart-4f1fda82-f333-421a-954b-0ba1f9d75037\" target=\"_blank\" rel=\"noopener\">\n<button class=\"btn-cta\"><b>CREATE THIS BAR CHART<\/b><\/button><\/a><\/center>&nbsp;\n\n\n\n<p>Oh and one more thing.&nbsp;<\/p>\n\n\n\n<p>Though not common, sometimes bar charts can include an additional horizontal or vertical secondary axis when there are more than two sets of data.<\/p>\n\n\n\n<p>For example, let\u2019s say you have a bar graph showing the sales revenue of different products on the primary vertical axis. To show the number of units sold for each product, you might add a secondary vertical axis.&nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"types\"><strong>Types of bar charts you can make in Excel<\/strong><\/h2>\n\n\n\n<p>Excel is known for helping people create several <a href=\"https:\/\/venngage.com\/blog\/types-of-charts\/\" target=\"_blank\" rel=\"noreferrer noopener\">types of charts<\/a> for different presentation needs.<\/p>\n\n\n\n<p>Besides the column chart in Excel, other options include a <a href=\"https:\/\/venngage.com\/templates\/charts\/pie\" target=\"_blank\" rel=\"noreferrer noopener\">pie chart<\/a>, <a href=\"https:\/\/venngage.com\/templates\/charts\/line\" target=\"_blank\" rel=\"noreferrer noopener\">line chart<\/a>, and <a href=\"https:\/\/venngage.com\/templates\/charts\/scatterplot\" target=\"_blank\" rel=\"noreferrer noopener\">scatterplot<\/a>.&nbsp;<\/p>\n\n\n\n<blockquote class=\"wp-block-quote\">\n<p>Not sure if a bar chart is the right choice for you? Check out our post on how to choose the <a href=\"https:\/\/venngage.com\/blog\/how-to-choose-the-best-charts-for-your-infographic\/\" target=\"_blank\" rel=\"noreferrer noopener\">best chart for your data<\/a> to help you decide.<\/p>\n<\/blockquote>\n\n\n\n<p>But if you&#8217;re confident a bar graph is what you need, the next step is to decide what type of bar chart you want to create.<\/p>\n\n\n\n<p>Excel provides various options for bar charts, including clustered, stacked, floating, and grouped bar charts, as well as histograms.<\/p>\n\n\n\n<p>For example, a stacked bar chart is helpful in comparing percentages or proportions within different categories while a clustered bar chart allows for straightforward comparisons of data across categories.<\/p>\n\n\n\n<p>However, you won&#8217;t find each type of bar chart in Excel.<\/p>\n\n\n\n<p>For instance, it\u2019s not possible to <a href=\"https:\/\/venngage.com\/features\/timeline-infographics\">create a timeline<\/a> or schedule bar chart (also known as a <a href=\"https:\/\/venngage.com\/templates\/diagrams\/gantt-chart\" target=\"_blank\" rel=\"noreferrer noopener\">Gantt chart<\/a>) in Excel unless you want to spend hours manually customizing the appearance.&nbsp;<\/p>\n\n\n\n<p>So why not head over to our selection of<a href=\"https:\/\/venngage.com\/templates\/charts\/bar\" target=\"_blank\" rel=\"noreferrer noopener\"> bar chart templates<\/a> where you\u2019ll find each of these types of bar charts ready to be made your own in a few clicks?<\/p>\n\n\n\n<p>Now, onto the type bar charts you <em>can <\/em>create in Excel:&nbsp;<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Clustered bar chart<\/h3>\n\n\n\n<p>I used to rely on clustered bar charts all the time when comparing department performance across quarters. <\/p>\n\n\n\n<p>Each group of bars sits side by side, so it\u2019s super easy to spot which team outperformed the others in Q2, for example. If you\u2019ve got multiple categories sharing the same metric, this chart\u2019s your go-to.<\/p>\n\n\n\n<p>Excel offers both 2D and 3D clustered bar chart options, which are widely used for data comparison.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"516\" src=\"https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2023\/07\/cluster-bar-charts-excel-2-1024x516.png\" alt=\"cluster bar chart excel\" class=\"wp-image-74072\" srcset=\"https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2023\/07\/cluster-bar-charts-excel-2-1024x516.png 1024w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2023\/07\/cluster-bar-charts-excel-2-300x151.png 300w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2023\/07\/cluster-bar-charts-excel-2-768x387.png 768w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2023\/07\/cluster-bar-charts-excel-2-1536x774.png 1536w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2023\/07\/cluster-bar-charts-excel-2-730x368.png 730w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2023\/07\/cluster-bar-charts-excel-2.png 1920w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Here\u2019s an example of a clustered bar chart:&nbsp;<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><a href=\"https:\/\/venngage.com\/templates\/charts\/clustered-stacked-bar-chart-1e921503-3e57-41be-ae86-a9c0992dd4a2\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"791\" src=\"https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2023\/07\/clustered-bar-chart-1-1024x791.png\" alt=\"Clustered Stacked Bar Chart\" class=\"wp-image-74701\" srcset=\"https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2023\/07\/clustered-bar-chart-1-1024x791.png 1024w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2023\/07\/clustered-bar-chart-1-300x232.png 300w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2023\/07\/clustered-bar-chart-1-768x593.png 768w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2023\/07\/clustered-bar-chart-1-730x564.png 730w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2023\/07\/clustered-bar-chart-1.png 1056w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure><\/div>\n\n\n<center><a href=\"https:\/\/venngage.com\/templates\/charts\/clustered-stacked-bar-chart-1e921503-3e57-41be-ae86-a9c0992dd4a2\" target=\"_blank\" rel=\"noopener\">\n<button class=\"btn-cta\"><b>CREATE THIS BAR CHART<\/b><\/button><\/a><\/center>&nbsp;\n\n\n\n<p>Clustered bar charts allow you to add overlapping bars to compare multiple series of data.<\/p>\n\n\n\n<p>In the example above, the adjacent nature of the clustered bars makes it easy to visualize how each cake flavor performs in different cities.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Stacked bar chart &#8211; visualizing cumulative totals<\/h3>\n\n\n\n<p>In a <a href=\"https:\/\/venngage.com\/templates\/charts\/stacked\" target=\"_blank\" rel=\"noreferrer noopener\">stacked bar chart<\/a>, bars are stacked on top of each other to represent the cumulative total of multiple data series.<\/p>\n\n\n\n<p>Each segment within a bar represents a different category or group, and the overall height of the bar represents the total value.<\/p>\n\n\n\n<p>When I was building a report to show overall marketing ROI by channel, the stacked bar chart made things click. It lets you stack segments on top of each other in a single bar, showing both the total and the individual parts. It\u2019s a great way to say, \u201cHere\u2019s the big picture, and here\u2019s how we got there.\u201d<\/p>\n\n\n\n<p>Of course, you can create stacked bar charts in Excel too.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"607\" src=\"https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2023\/07\/stacked-bar-charts-excel-1-1024x607.png\" alt=\"stacked bar charts excel\" class=\"wp-image-74073\" srcset=\"https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2023\/07\/stacked-bar-charts-excel-1-1024x607.png 1024w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2023\/07\/stacked-bar-charts-excel-1-300x178.png 300w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2023\/07\/stacked-bar-charts-excel-1-768x455.png 768w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2023\/07\/stacked-bar-charts-excel-1-730x433.png 730w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2023\/07\/stacked-bar-charts-excel-1.png 1193w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Here\u2019s a real-world example:<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><a href=\"https:\/\/venngage.com\/templates\/charts\/free-chart-template-6819b64e-7060-48ab-aada-397b480d4dcc\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" loading=\"lazy\" width=\"791\" height=\"1024\" src=\"https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2023\/07\/stacked-bar-chart-example11-1-791x1024.png\" alt=\"Free Chart Template\" class=\"wp-image-74703\" srcset=\"https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2023\/07\/stacked-bar-chart-example11-1-791x1024.png 791w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2023\/07\/stacked-bar-chart-example11-1-232x300.png 232w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2023\/07\/stacked-bar-chart-example11-1-768x994.png 768w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2023\/07\/stacked-bar-chart-example11-1-730x945.png 730w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2023\/07\/stacked-bar-chart-example11-1.png 816w\" sizes=\"(max-width: 791px) 100vw, 791px\" \/><\/a><\/figure><\/div>\n\n\n<center><a href=\"https:\/\/venngage.com\/templates\/charts\/free-chart-template-6819b64e-7060-48ab-aada-397b480d4dcc\" target=\"_blank\" rel=\"noopener\">\n<button class=\"btn-cta\"><b>CREATE THIS BAR CHART<\/b><\/button><\/a><\/center>&nbsp;\n\n\n\n<h3 class=\"wp-block-heading\">Grouped bar chart<\/h3>\n\n\n\n<p>Grouped bar charts organize multiple bars within larger category groups, helping you compare subcategories easily.<\/p>\n\n\n\n<p>These came in handy when I was tracking how many customers were acquired in each quarter.<\/p>\n\n\n\n<p>Take this clustered column chart template for example, Q1 to Q4 data were grouped under each service, like SEO, PPC and social media management. It was a clear way to show what services are in demand so that the company can prioritize its resources. <\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large is-resized\"><a href=\"https:\/\/venngage.com\/templates\/charts\/clustered-column-chart-971ec2e5-c662-4029-a4f1-67d6fe5ebefb\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" src=\"https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2025\/07\/image-7-1024x791.png\" alt=\"Digital Marketing Services Bar Chart Template\n\" class=\"wp-image-104449\" width=\"700\" srcset=\"https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2025\/07\/image-7-1024x791.png 1024w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2025\/07\/image-7-300x232.png 300w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2025\/07\/image-7-768x593.png 768w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2025\/07\/image-7-730x564.png 730w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2025\/07\/image-7.png 1056w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<center><a href=\"https:\/\/venngage.com\/templates\/charts\/clustered-column-chart-971ec2e5-c662-4029-a4f1-67d6fe5ebefb\" target=\"_blank\" rel=\"noopener\">\n<button class=\"btn-cta\"><b>CREATE THIS BAR CHART<\/b><\/button><\/a><\/center>&nbsp;\n\n\n\n<h3 class=\"wp-block-heading\">Percentage bar chart<\/h3>\n\n\n\n<p>A percentage bar chart standardizes all bars to 100%, so you can focus on proportions instead of totals.<\/p>\n\n\n\n<p>I remember presenting a report and watching everyone\u2019s eyes glaze over until I switched to a percentage bar chart. <\/p>\n\n\n\n<p>Suddenly, it was clear that Product A had lost ground to B, even though the raw numbers didn\u2019t make it obvious. It\u2019s one of those &#8220;why didn\u2019t I do this earlier?&#8221; tools.<\/p>\n\n\n\n<p>You can visualize this kind of data using <span style=\"box-sizing: border-box; margin: 0px; padding: 0px;\">this<\/span> template, which includes clean, customizable charts ideal for highlighting proportional trends, like time allocation or task breakdowns, without overwhelming your audience with raw figures.<\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><a href=\"https:\/\/venngage.com\/templates\/reports\/team-productivity-data-dashboard-report-5b70a80a-6d19-4bac-a27f-c62efde5b5d7\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" loading=\"lazy\" width=\"640\" height=\"495\" src=\"https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2025\/07\/image-9.png\" alt=\"Team Productivity Data Dashboard Report\n\" class=\"wp-image-104453\" srcset=\"https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2025\/07\/image-9.png 640w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2025\/07\/image-9-300x232.png 300w\" sizes=\"(max-width: 640px) 100vw, 640px\" \/><\/a><\/figure>\n\n\n\n<center><a href=\"https:\/\/venngage.com\/templates\/reports\/team-productivity-data-dashboard-report-5b70a80a-6d19-4bac-a27f-c62efde5b5d7\" target=\"_blank\" rel=\"noopener\">\n<button class=\"btn-cta\"><b>CREATE THIS BAR CHART<\/b><\/button><\/a><\/center>&nbsp;\n\n\n\n<h3 class=\"wp-block-heading\">Double bar chart<\/h3>\n\n\n\n<p>Double bar charts show two bars per category, letting you compare two related data sets side by side.<\/p>\n\n\n\n<p>These are my go-to for before-and-after visuals. Two bars per category, easy to build, even easier to explain. It\u2019s clean, direct and tells a story fast.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img decoding=\"async\" src=\"https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2025\/07\/image-10.png\" alt=\"Double bar chart example\" class=\"wp-image-104454\" width=\"700\" srcset=\"https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2025\/07\/image-10.png 891w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2025\/07\/image-10-300x149.png 300w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2025\/07\/image-10-768x381.png 768w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2025\/07\/image-10-730x362.png 730w\" sizes=\"(max-width: 891px) 100vw, 891px\" \/><\/figure><\/div>\n\n\n<p class=\"has-text-align-center\"><a href=\"https:\/\/www.myexcelonline.com\/blog\/double-bar-graph-in-excel\/\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">Source<\/a><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Bar chart with 3 variables<\/h3>\n\n\n\n<p>Okay, this one takes a bit of creativity. This type of bar chart uses visual tricks like color coding or pivot charts to show a third variable alongside the basic bar data.<\/p>\n\n\n\n<p>I once had to show product sales by region <em>and<\/em> channel type. One workaround was adding color to represent the third variable using a pivot chart. <\/p>\n\n\n\n<p>Another time, I used varying patterns instead. It\u2019s not perfect, but with the right formatting, it totally works and helps people grasp more complex stories without overwhelming them.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"excel\"><strong>How to make a bar chart in Excel (with screenshots)<\/strong><\/h2>\n\n\n\n<p>Creating a bar chart in Excel is quick and effective for visualizing data. In this tutorial, we\u2019re using Microsoft Excel for Microsoft 365 (Office 365) to ensure compatibility with the latest UI and features.<\/p>\n\n\n\n<p>Follow these four steps to create a clean, professional bar chart from scratch.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 1 \u2013 Enter your data in Excel<\/strong><\/h3>\n\n\n\n<p>Start by organizing your data in two columns:<\/p>\n\n\n\n<ul>\n<li>The first column for categories (e.g. country names)<\/li>\n\n\n\n<li>The second column for values (e.g. population sizes)<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><img decoding=\"async\" src=\"https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2025\/07\/Bar-Chart-Excel-1-1024x756.png\" alt=\"Step 1 \u2013 Enter your data in Excel\" class=\"wp-image-104748\" width=\"700\" srcset=\"https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2025\/07\/Bar-Chart-Excel-1-1024x756.png 1024w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2025\/07\/Bar-Chart-Excel-1-300x221.png 300w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2025\/07\/Bar-Chart-Excel-1-768x567.png 768w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2025\/07\/Bar-Chart-Excel-1-730x539.png 730w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2025\/07\/Bar-Chart-Excel-1.png 1522w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 2 \u2013 Insert a bar chart from the ribbon<\/strong><\/h3>\n\n\n\n<ol>\n<li>Select the entire data range, including headers.<\/li>\n\n\n\n<li>Go to the <strong>Insert<\/strong> tab in the ribbon.<\/li>\n\n\n\n<li>In the <strong>Charts<\/strong> group, click the <strong>Insert Column or Bar Chart<\/strong> icon.<\/li>\n\n\n\n<li>Choose a bar chart type\u2014<strong>Clustered Bar<\/strong> is a popular option.<\/li>\n<\/ol>\n\n\n\n<p><strong>Tip: <\/strong>Excel refers to vertical bar charts as \u201cColumn Charts\u201d and horizontal ones as \u201cBar Charts.\u201d Pick the one that suits your layout.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><img decoding=\"async\" src=\"https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2025\/07\/Bar-Chart-Excel-2-1024x640.png\" alt=\"Step 2 \u2013 Insert a bar chart from the ribbon\" class=\"wp-image-104750\" width=\"700\" srcset=\"https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2025\/07\/Bar-Chart-Excel-2-1024x640.png 1024w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2025\/07\/Bar-Chart-Excel-2-300x188.png 300w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2025\/07\/Bar-Chart-Excel-2-768x480.png 768w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2025\/07\/Bar-Chart-Excel-2-1536x960.png 1536w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2025\/07\/Bar-Chart-Excel-2-2048x1280.png 2048w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2025\/07\/Bar-Chart-Excel-2-730x456.png 730w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 3 \u2013 Customize the chart layout and colors<\/strong><\/h3>\n\n\n\n<p>Once the chart appears:<\/p>\n\n\n\n<ul>\n<li>Click the chart to activate <strong>Chart Design<\/strong> and <strong>Format<\/strong> tabs.<\/li>\n\n\n\n<li>Use <strong>Chart Styles<\/strong> to apply a pre-designed color theme.<\/li>\n\n\n\n<li>Click <strong>Change Colors<\/strong> to apply your brand palette or a more readable combination.<\/li>\n\n\n\n<li>Right-click any bar to manually format fill colors, outlines, or add gradients.<\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><img decoding=\"async\" src=\"https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2025\/07\/Bar-Chart-Excel-3-1-1024x640.png\" alt=\"Step 3 \u2013 Customize the chart layout and colors\" class=\"wp-image-104752\" width=\"700\" srcset=\"https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2025\/07\/Bar-Chart-Excel-3-1-1024x640.png 1024w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2025\/07\/Bar-Chart-Excel-3-1-300x188.png 300w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2025\/07\/Bar-Chart-Excel-3-1-768x480.png 768w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2025\/07\/Bar-Chart-Excel-3-1-1536x960.png 1536w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2025\/07\/Bar-Chart-Excel-3-1-2048x1280.png 2048w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2025\/07\/Bar-Chart-Excel-3-1-730x456.png 730w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n<p>For clearer visuals:<\/p>\n\n\n\n<ul>\n<li>Avoid cluttered color schemes<\/li>\n\n\n\n<li>Use contrasting colors for high\/low values<\/li>\n\n\n\n<li>Remove unnecessary 3D effects for clean presentation<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Step 4 \u2013 Format labels, axis titles and gridlines<\/strong><\/h3>\n\n\n\n<p>Fine-tune your chart for clarity:<\/p>\n\n\n\n<ul>\n<li>Click on the chart title to edit it<\/li>\n\n\n\n<li>Use the <strong>Chart Elements (+)<\/strong> button (top right of the chart) to toggle:\n<ul>\n<li>Axis titles<\/li>\n\n\n\n<li>Data labels<\/li>\n\n\n\n<li>Gridlines<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Format axis titles for clarity (e.g. \u201cCountry\u201d on X-axis, \u201cPopulation\u201d on Y-axis)<\/li>\n\n\n\n<li>Adjust data label position (inside or outside bars) for better readability<\/li>\n<\/ul>\n\n\n\n<p><strong>Tip: <\/strong>Keep your chart minimalist\u2014use only the labels and gridlines that add value. You can also use\u00a0<a href=\"https:\/\/gptforwork.com\/gpt-for-excel\" target=\"_blank\" rel=\"noreferrer noopener\">GPT for Excel<\/a>\u00a0to generate and format chart data faster using AI prompts directly inside your spreadsheet.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large is-resized\"><img decoding=\"async\" src=\"https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2025\/07\/Bar-Chart-Excel-4-1024x640.png\" alt=\"Step 4 \u2013 Format labels, axis titles and gridlines\" class=\"wp-image-104755\" width=\"700\" srcset=\"https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2025\/07\/Bar-Chart-Excel-4-1024x640.png 1024w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2025\/07\/Bar-Chart-Excel-4-300x188.png 300w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2025\/07\/Bar-Chart-Excel-4-768x480.png 768w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2025\/07\/Bar-Chart-Excel-4-1536x960.png 1536w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2025\/07\/Bar-Chart-Excel-4-2048x1280.png 2048w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2025\/07\/Bar-Chart-Excel-4-730x456.png 730w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n<h2 class=\"wp-block-heading\" id=\"venngage\">How to make better bar charts with Venngage<\/h2>\n\n\n\n<p>Of course, Excel isn&#8217;t the <em>only <\/em>way to make a column chart.<\/p>\n\n\n\n<p>With limitations in flexibility, customization options, or the ability to edit and collaborate in real time, Excel is not the best way to create bar charts.<\/p>\n\n\n\n<p>With Venngage, you can really elevate your bar charts thanks to our intuitive editor tool and professional<a href=\"https:\/\/venngage.com\/templates\/charts\/bar\" target=\"_blank\" rel=\"noreferrer noopener\"> bar chart templates<\/a> that showcase progress and key performance indicators effectively.<\/p>\n\n\n\n<p>Here&#8217;s what you need to do:<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Step 1 &#8211; Sign up for a Venngage account (it&#8217;s free!)<\/h3>\n\n\n\n<p>Start by&nbsp;<a href=\"https:\/\/infograph.venngage.com\/register\" target=\"_blank\" rel=\"noreferrer noopener\">signing up<\/a>&nbsp;for Venngage&nbsp;with your email, Gmail or Facebook account.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/infograph.venngage.com\/register\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"518\" src=\"https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2023\/06\/venngage-sign-up-1-1024x518.png\" alt=\"venngage sign up\" class=\"wp-image-73580\" srcset=\"https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2023\/06\/venngage-sign-up-1-1024x518.png 1024w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2023\/06\/venngage-sign-up-1-300x152.png 300w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2023\/06\/venngage-sign-up-1-768x388.png 768w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2023\/06\/venngage-sign-up-1-1536x777.png 1536w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2023\/06\/venngage-sign-up-1-730x369.png 730w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2023\/06\/venngage-sign-up-1.png 1916w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Step 2 &#8211; Select a template from our library<\/h3>\n\n\n\n<p>Venngage has a diverse range of <a href=\"https:\/\/venngage.com\/templates\/charts\/bar\" target=\"_blank\" rel=\"noreferrer noopener\">bar chart templates<\/a>&nbsp;to choose from. Whether you&#8217;re looking for <a href=\"https:\/\/venngage.com\/templates\/charts\/stacked\" target=\"_blank\" rel=\"noreferrer noopener\">stacked bar charts<\/a>, a vertical bar graph, or a horizontal bar chart, we&#8217;ve got templates for you to edit. <\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"577\" src=\"https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2023\/07\/bar-chart-templates-1-1024x577.png\" alt=\"bar chart templates venngage\" class=\"wp-image-74012\" srcset=\"https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2023\/07\/bar-chart-templates-1-1024x577.png 1024w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2023\/07\/bar-chart-templates-1-300x169.png 300w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2023\/07\/bar-chart-templates-1-768x433.png 768w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2023\/07\/bar-chart-templates-1-1536x866.png 1536w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2023\/07\/bar-chart-templates-1-730x412.png 730w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2023\/07\/bar-chart-templates-1.png 1580w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n<p>For example, here&#8217;s a beautiful stacked bar chart you can make your own:<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/venngage.com\/templates\/charts\/thermometer-graph-marketing-stats-template-f2d8b10f-db49-4fda-9f32-8111f17f11a9\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2023\/07\/stacked-bar-chart-template-1.png\" alt=\"Thermometer Graph Marketing Stats Template\" class=\"wp-image-74078\" width=\"612\" height=\"589\" srcset=\"https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2023\/07\/stacked-bar-chart-template-1.png 816w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2023\/07\/stacked-bar-chart-template-1-300x289.png 300w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2023\/07\/stacked-bar-chart-template-1-768x739.png 768w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2023\/07\/stacked-bar-chart-template-1-730x702.png 730w\" sizes=\"(max-width: 612px) 100vw, 612px\" \/><\/a><\/figure><\/div>\n\n\n<center><a href=\"https:\/\/venngage.com\/templates\/charts\/thermometer-graph-marketing-stats-template-f2d8b10f-db49-4fda-9f32-8111f17f11a9\" target=\"_blank\" rel=\"noopener\">\n<button class=\"btn-cta\"><b>CREATE THIS BAR CHART<\/b><\/button><\/a><\/center>&nbsp;\n\n\n\n<p>Or this stunning horizontal bar chart.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><a href=\"https:\/\/venngage.com\/templates\/charts\/visual-content-marketing-design-bar-chart-a252a257-98d4-47de-87cb-ae5b1b34d8ac\" target=\"_blank\" rel=\"noreferrer noopener\"><img decoding=\"async\" loading=\"lazy\" src=\"https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2023\/07\/horizontal-bar-chart-1.png\" alt=\"Visual Content Marketing Design Bar Chart\" class=\"wp-image-74079\" width=\"612\" height=\"527\" srcset=\"https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2023\/07\/horizontal-bar-chart-1.png 816w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2023\/07\/horizontal-bar-chart-1-300x258.png 300w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2023\/07\/horizontal-bar-chart-1-768x662.png 768w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2023\/07\/horizontal-bar-chart-1-730x629.png 730w\" sizes=\"(max-width: 612px) 100vw, 612px\" \/><\/a><\/figure><\/div>\n\n\n<center><a href=\"https:\/\/venngage.com\/templates\/charts\/visual-content-marketing-design-bar-chart-a252a257-98d4-47de-87cb-ae5b1b34d8ac\" target=\"_blank\" rel=\"noopener\">\n<button class=\"btn-cta\"><b>CREATE THIS BAR CHART<\/b><\/button><\/a><\/center>&nbsp;\n\n\n\n<h3 class=\"wp-block-heading\">Step 3 &#8211; Edit your bar chart in a few clicks<\/h3>\n\n\n\n<p>Have no design experience? No sweat!<\/p>\n\n\n\n<p>All our templates are easy to edit thanks to a drag-and-drop interface. <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2022\/02\/Bar-Chart-Maker.gif\" alt=\"bar graph maker gif\"\/><\/figure>\n\n\n\n<p>Swap placeholder data with your own in a spreadsheet interface.<\/p>\n\n\n\n<p>But that&#8217;s not all. <\/p>\n\n\n\n<p>Venngage also offers 40,000 icons and illustrations to help you visualize and bring bar charts to life. This will ensure your next assignment, presentation, or report is not dull and grey.<\/p>\n\n\n\n<p>And if you upgrade to a&nbsp;<a href=\"https:\/\/venngage.com\/blog\/business\" target=\"_blank\" rel=\"noreferrer noopener\">Business<\/a>&nbsp;account, you can also enjoy&nbsp;<a href=\"https:\/\/venngage.com\/blog\/my-brand-kit\/\" target=\"_blank\" rel=\"noreferrer noopener\">My Brand Kit&nbsp;<\/a>\u2014 the one-click branding kit that lets you upload your logo and apply <a href=\"https:\/\/venngage.com\/blog\/brand-colors\/\">brand colors<\/a> and fonts to any design.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"1024\" height=\"611\" src=\"https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2023\/06\/mybrandkit-1024x611.gif\" alt=\"venngage my brand kit\" class=\"wp-image-73172\" srcset=\"https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2023\/06\/mybrandkit-1024x611.gif 1024w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2023\/06\/mybrandkit-300x179.gif 300w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2023\/06\/mybrandkit-768x459.gif 768w, https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2023\/06\/mybrandkit-730x436.gif 730w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>A business account also includes a&nbsp;<a href=\"https:\/\/venngage.com\/blog\/real-time-collaboration\/\" target=\"_blank\" rel=\"noreferrer noopener\">real-time collaboration feature<\/a>, so you can invite members of your team to work simultaneously on a project.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Step 4 &#8211; Share a link to your bar chart for free or upgrade to download<\/h3>\n\n\n\n<p>When you upgrade to a&nbsp;<a href=\"https:\/\/venngage.com\/blog\/business\" target=\"_blank\" rel=\"noreferrer noopener\">Business<\/a>&nbsp;account, you can download your quote poster as a PNG, PDF, or interactive PDF.<\/p>\n\n\n\n<p>But you can always share your quote poster online for free.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Frequently Asked Questions<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"faq-question-1\">How to make a column graph in Excel? <\/h3>\n\n\n\n<p>To create a column graph in Microsoft Excel, follow these steps: 1) Enter your data, 2) Select your data range, 3) Insert a column graph, 4) Choose a column chart type, 5) Let Excel create the chart, 6) Customize the bar chart to your needs, and 7) Save and export.&nbsp;<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"faq-question-2\">How to make a grouped bar chart in Excel?<\/h3>\n\n\n\n<p>To create a grouped bar chart in Excel, follow these steps: 1) Enter your data, 2) Select your data range, 3) Insert a grouped bar chart, 4) Customize your chart, 5) Add axis labels and titles, and 6) Save and export.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"faq-question-3\">How to make a percentage bar graph in Excel?<\/h3>\n\n\n\n<p>To create a percentage bar graph in Excel, follow these steps: 1) Enter your data, 2) Calculate your percentages, 3) Select your data range, 4) Insert a clustered column bar chart, 5) Switch to the percentage scale, 6) Customize the chart, 7) Add axis labels and titles, and 8) Save and export.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"faq-question-4\">How to make a bar graph in Excel with 3 variables?<\/h3>\n\n\n\n<p>To make a bar graph in Excel with 3 variables, follow these steps: 1) Enter your data, 2) Select your data range, 3) Insert a clustered column chart, 4) Customize your chart, 5) Add axis labels and titles, and 6) Save and export your clustered bar chart.&nbsp;<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"faq-question-5\">How to make a double bar graph in Excel?<\/h3>\n\n\n\n<p>To create a double bar graph in Excel, follow these steps: 1) Enter your data, 2) Select your data range, 3) Insert a clustered bar chart, 4) Customize your chart, 5) Add axis labels and titles 6) group the bars by right-clicking on a bar and selecting &#8220;Format Data Series&#8221; from the menu. Here, change &#8220;Series Overlap&#8221; and &#8220;Gap Width&#8221; settings to adjust the spacing between the bars to 0 to create a double bar graph, and 7) Save and export.&nbsp;<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"faq-question-6\">How do I create a bar chart in Excel with multiple bars?<\/h3>\n\n\n\n<p>To create a bar chart in Excel with multiple bars, follow these instructions: 1) Enter your data, 2) Select your data range, 3) Choose the type of bar chart you want to create, 4) Select the \u201c<a href=\"https:\/\/venngage.com\/blog\/chart-design\/\">Chart Design<\/a>\u201d option in the \u201cData\u201d tab and click on \u201cSwitch Row\/Column\u201d button, 5) Save and export.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusion<\/h2>\n\n\n\n<p>With Venngage, it&#8217;s easy to elevate your data visualization game and create stunning bar charts that grab the attention of a reader or audience. <\/p>\n\n\n\n<p>Or you can make boring bar charts with Excel that puts people to sleep.<\/p>\n\n\n\n<p>What choice will you go with?<\/p>\n\n\n\n<center><a href=\"https:\/\/venngage.com\/templates\/charts\/bar\" target=\"_blank\" rel=\"noopener\">\n<button class=\"btn-cta\"><b>START CREATING FOR FREE<\/b><\/button><\/a><\/center>&nbsp;\n","protected":false},"excerpt":{"rendered":"<p>As someone who\u2019s worked with data across reports, presentations, and marketing materials, I know how valuable a well-designed bar chart can be. It\u2019s one of the simplest and most effective ways to visualize comparisons and trends. Most people start with Excel or Google Sheets. And while those tools can create functional charts, they often lack [&hellip;]<\/p>\n","protected":false},"author":150,"featured_media":74413,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false},"categories":[188,610],"tags":[220,226],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v17.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<meta name=\"description\" content=\"Follow this step-by-step guide to create bar charts in Excel\u2014then make clearer, faster charts using Venngage\u2019s free templates and chart maker.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/venngage.com\/blog\/bar-chart-in-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Make a Bar Chart in Excel: Examples + Free Tool - Venngage\" \/>\n<meta property=\"og:description\" content=\"Follow this step-by-step guide to create bar charts in Excel\u2014then make clearer, faster charts using Venngage\u2019s free templates and chart maker.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/venngage.com\/blog\/bar-chart-in-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Venngage\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/Venngage\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-26T05:00:36+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-03-27T17:27:16+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2023\/07\/bar-chart-excel-header-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t<meta property=\"og:image:height\" content=\"576\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@venngage\" \/>\n<meta name=\"twitter:site\" content=\"@venngage\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Aditya Rana\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"12 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/venngage.com\/blog\/#website\",\"url\":\"https:\/\/venngage.com\/blog\/\",\"name\":\"Venngage\",\"description\":\"Learn to Communicate with Data\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/venngage.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/venngage.com\/blog\/bar-chart-in-excel\/#primaryimage\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2023\/07\/bar-chart-excel-header-1.png\",\"contentUrl\":\"https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2023\/07\/bar-chart-excel-header-1.png\",\"width\":1024,\"height\":576,\"caption\":\"how to make bar chart in excel\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/venngage.com\/blog\/bar-chart-in-excel\/#webpage\",\"url\":\"https:\/\/venngage.com\/blog\/bar-chart-in-excel\/\",\"name\":\"How to Make a Bar Chart in Excel: Examples + Free Tool - Venngage\",\"isPartOf\":{\"@id\":\"https:\/\/venngage.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/venngage.com\/blog\/bar-chart-in-excel\/#primaryimage\"},\"datePublished\":\"2023-07-26T05:00:36+00:00\",\"dateModified\":\"2026-03-27T17:27:16+00:00\",\"author\":{\"@id\":\"https:\/\/venngage.com\/blog\/#\/schema\/person\/dfb7abe372a17f134b803eb9946b489e\"},\"description\":\"Follow this step-by-step guide to create bar charts in Excel\\u2014then make clearer, faster charts using Venngage\\u2019s free templates and chart maker.\",\"breadcrumb\":{\"@id\":\"https:\/\/venngage.com\/blog\/bar-chart-in-excel\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/venngage.com\/blog\/bar-chart-in-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/venngage.com\/blog\/bar-chart-in-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Blog\",\"item\":\"https:\/\/venngage.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Beginner Guides\",\"item\":\"https:\/\/venngage.com\/blog\/category\/beginner-guides\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"How to Make a Bar Chart in Excel: Examples + Free Tool\"}]},{\"@type\":\"Person\",\"@id\":\"https:\/\/venngage.com\/blog\/#\/schema\/person\/dfb7abe372a17f134b803eb9946b489e\",\"name\":\"Aditya Rana\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/venngage.com\/blog\/#personlogo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/4f7af5d78ab9105590fe0c201978b7b4?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/4f7af5d78ab9105590fe0c201978b7b4?s=96&d=mm&r=g\",\"caption\":\"Aditya Rana\"},\"description\":\"Aditya is a writer and editor at Venngage, specializing in creating informative content on topics ranging from PDF accessibility and graphic design software to project planning and infographic creation.\",\"url\":\"https:\/\/venngage.com\/blog\/author\/adivenngage-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"description":"Follow this step-by-step guide to create bar charts in Excel\u2014then make clearer, faster charts using Venngage\u2019s free templates and chart maker.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/venngage.com\/blog\/bar-chart-in-excel\/","og_locale":"en_US","og_type":"article","og_title":"How to Make a Bar Chart in Excel: Examples + Free Tool - Venngage","og_description":"Follow this step-by-step guide to create bar charts in Excel\u2014then make clearer, faster charts using Venngage\u2019s free templates and chart maker.","og_url":"https:\/\/venngage.com\/blog\/bar-chart-in-excel\/","og_site_name":"Venngage","article_publisher":"https:\/\/www.facebook.com\/Venngage","article_published_time":"2023-07-26T05:00:36+00:00","article_modified_time":"2026-03-27T17:27:16+00:00","og_image":[{"width":1024,"height":576,"url":"https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2023\/07\/bar-chart-excel-header-1.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_creator":"@venngage","twitter_site":"@venngage","twitter_misc":{"Written by":"Aditya Rana","Est. reading time":"12 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebSite","@id":"https:\/\/venngage.com\/blog\/#website","url":"https:\/\/venngage.com\/blog\/","name":"Venngage","description":"Learn to Communicate with Data","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/venngage.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"ImageObject","@id":"https:\/\/venngage.com\/blog\/bar-chart-in-excel\/#primaryimage","inLanguage":"en-US","url":"https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2023\/07\/bar-chart-excel-header-1.png","contentUrl":"https:\/\/venngage-wordpress.s3.amazonaws.com\/uploads\/2023\/07\/bar-chart-excel-header-1.png","width":1024,"height":576,"caption":"how to make bar chart in excel"},{"@type":"WebPage","@id":"https:\/\/venngage.com\/blog\/bar-chart-in-excel\/#webpage","url":"https:\/\/venngage.com\/blog\/bar-chart-in-excel\/","name":"How to Make a Bar Chart in Excel: Examples + Free Tool - Venngage","isPartOf":{"@id":"https:\/\/venngage.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/venngage.com\/blog\/bar-chart-in-excel\/#primaryimage"},"datePublished":"2023-07-26T05:00:36+00:00","dateModified":"2026-03-27T17:27:16+00:00","author":{"@id":"https:\/\/venngage.com\/blog\/#\/schema\/person\/dfb7abe372a17f134b803eb9946b489e"},"description":"Follow this step-by-step guide to create bar charts in Excel\u2014then make clearer, faster charts using Venngage\u2019s free templates and chart maker.","breadcrumb":{"@id":"https:\/\/venngage.com\/blog\/bar-chart-in-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/venngage.com\/blog\/bar-chart-in-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/venngage.com\/blog\/bar-chart-in-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog","item":"https:\/\/venngage.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Beginner Guides","item":"https:\/\/venngage.com\/blog\/category\/beginner-guides\/"},{"@type":"ListItem","position":3,"name":"How to Make a Bar Chart in Excel: Examples + Free Tool"}]},{"@type":"Person","@id":"https:\/\/venngage.com\/blog\/#\/schema\/person\/dfb7abe372a17f134b803eb9946b489e","name":"Aditya Rana","image":{"@type":"ImageObject","@id":"https:\/\/venngage.com\/blog\/#personlogo","inLanguage":"en-US","url":"https:\/\/secure.gravatar.com\/avatar\/4f7af5d78ab9105590fe0c201978b7b4?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4f7af5d78ab9105590fe0c201978b7b4?s=96&d=mm&r=g","caption":"Aditya Rana"},"description":"Aditya is a writer and editor at Venngage, specializing in creating informative content on topics ranging from PDF accessibility and graphic design software to project planning and infographic creation.","url":"https:\/\/venngage.com\/blog\/author\/adivenngage-com\/"}]}},"_links":{"self":[{"href":"https:\/\/venngage.com\/blog\/wp-json\/wp\/v2\/posts\/73942"}],"collection":[{"href":"https:\/\/venngage.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/venngage.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/venngage.com\/blog\/wp-json\/wp\/v2\/users\/150"}],"replies":[{"embeddable":true,"href":"https:\/\/venngage.com\/blog\/wp-json\/wp\/v2\/comments?post=73942"}],"version-history":[{"count":64,"href":"https:\/\/venngage.com\/blog\/wp-json\/wp\/v2\/posts\/73942\/revisions"}],"predecessor-version":[{"id":111233,"href":"https:\/\/venngage.com\/blog\/wp-json\/wp\/v2\/posts\/73942\/revisions\/111233"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/venngage.com\/blog\/wp-json\/wp\/v2\/media\/74413"}],"wp:attachment":[{"href":"https:\/\/venngage.com\/blog\/wp-json\/wp\/v2\/media?parent=73942"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/venngage.com\/blog\/wp-json\/wp\/v2\/categories?post=73942"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/venngage.com\/blog\/wp-json\/wp\/v2\/tags?post=73942"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}