{"id":8997,"date":"2023-03-13T02:17:13","date_gmt":"2023-03-13T02:17:13","guid":{"rendered":"https:\/\/www.excel-learn.com\/?p=8997"},"modified":"2023-03-13T02:17:13","modified_gmt":"2023-03-13T02:17:13","slug":"clustered-bar-charts-in-excel","status":"publish","type":"post","link":"https:\/\/www.excel-learn.com\/clustered-bar-charts-in-excel\/","title":{"rendered":"3 Examples to Create Clustered Bar Charts in Excel"},"content":{"rendered":"

Step by Step of creating bar chart in Excel<\/strong><\/h3>\n

To create a bar chart in Excel, follow these steps:<\/p>\n

Step 1:<\/strong><\/p>\n

Select the data in the sheet. We will create an Inflation chart year by year (for demo only).<\/p>\n

\"Excel-bar-Clustered-data\"<\/p>\n

Step 2:<\/strong><\/p>\n

Go to Insert<\/strong> in the ribbon and click on \u201cRecommended Charts<\/strong>\u201d<\/p>\n

\"recommended\"<\/p>\n

Step 3:<\/strong><\/p>\n

In the \u201cInsert Charts<\/strong>\u201d dialog, click on the \u201cAll Charts<\/strong>\u201d tab:<\/p>\n

\"All-charts\"<\/p>\n

Step 4:<\/strong><\/p>\n

Click on the Bar<\/strong> on the left pane, \u201cClustered bar<\/strong>\u201d is selected by default on the right.<\/p>\n

\"clusrered-chart\"<\/p>\n

We selected the third template.<\/p>\n

Result:<\/strong><\/p>\n

\"clusrered-chart-result\"<\/p>\n

Changing the chart title<\/strong><\/h3>\n

To change the charge title, just click on it and delete the existing one.<\/p>\n

Type your chart name. We give \u201cInflation Chart\u201d, the title of our clustered bar chart:<\/p>\n

\"clusrered-chart-title\"<\/p>\n

Using another style for clustered bar chart<\/strong><\/h3>\n

If you want to change the style of clustered bar chart then follow these two steps.<\/p>\n

Step 1:<\/strong><\/p>\n

After selecting the chart that we just created, click on the \u201cBrush\u201d icon as shown below:<\/p>\n

\"clusrered-chart-style\"<\/p>\n

Step 2:<\/strong><\/p>\n

Under \u201cStyle\u201d (selected by default), you can see the list of available styles.<\/p>\n

We chose \u201cstyle 8\u201d and see the result:<\/p>\n

\"clusrered-chart-style-\"<\/p>\n

Similarly, you may choose a different color scheme by going to \u201cColor\u201d option adjacent to the \u201cStyle\u201d.<\/p>\n

Just hover the mouse over various color schemes and Excel will show the impact on the chart real-time.<\/p>\n

\"clusrered-colors\"<\/p>\n

Adding\/Removing chart elements<\/strong><\/h3>\n

You may manage chart elements by clicking on the +<\/strong> icon after selecting the chart. A few elements are added by default like:<\/p>\n

    \n
  • Axes<\/li>\n
  • Chart Title<\/li>\n
  • Data Labels<\/li>\n
  • Gridlines<\/li>\n
  • Legend<\/li>\n
  • Trendline<\/li>\n<\/ul>\n

    Others are:<\/p>\n

      \n
    • Axis Titles<\/li>\n
    • Data Tables<\/li>\n
    • Error Bars<\/li>\n<\/ul>\n

      You may just check\/uncheck to see the impact on the graph.<\/p>\n","protected":false},"excerpt":{"rendered":"

      Go to Insert in the ribbon and click on \u201cRecommended Charts\u201d<\/p>\n","protected":false},"author":1,"featured_media":8999,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[71],"tags":[],"yoast_head":"\n3 Examples to Create Clustered Bar Charts in Excel<\/title>\n<meta name=\"description\" content=\"Go to Insert in the ribbon and click on \u201cRecommended Charts\u201d\" \/>\n<meta name=\"robots\" content=\"index, follow\" \/>\n<meta name=\"googlebot\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<meta name=\"bingbot\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.excel-learn.com\/clustered-bar-charts-in-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"3 Examples to Create Clustered Bar Charts in Excel\" \/>\n<meta property=\"og:description\" content=\"Go to Insert in the ribbon and click on \u201cRecommended Charts\u201d\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.excel-learn.com\/clustered-bar-charts-in-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-03-13T02:17:13+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2023\/02\/65_7-clusrered-chart-style-.png\" \/>\n\t<meta property=\"og:image:width\" content=\"482\" \/>\n\t<meta property=\"og:image:height\" content=\"314\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.excel-learn.com\/#website\",\"url\":\"https:\/\/www.excel-learn.com\/\",\"name\":\"Excel Tutorials\",\"description\":\"Tips, Solutions, Tricks\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":\"https:\/\/www.excel-learn.com\/?s={search_term_string}\",\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.excel-learn.com\/clustered-bar-charts-in-excel\/#primaryimage\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/www.excel-learn.com\/wp-content\/uploads\/2023\/02\/65_7-clusrered-chart-style-.png\",\"width\":482,\"height\":314,\"caption\":\"clusrered-chart-style-\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.excel-learn.com\/clustered-bar-charts-in-excel\/#webpage\",\"url\":\"https:\/\/www.excel-learn.com\/clustered-bar-charts-in-excel\/\",\"name\":\"3 Examples to Create Clustered Bar Charts in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/www.excel-learn.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.excel-learn.com\/clustered-bar-charts-in-excel\/#primaryimage\"},\"datePublished\":\"2023-03-13T02:17:13+00:00\",\"dateModified\":\"2023-03-13T02:17:13+00:00\",\"author\":{\"@id\":\"https:\/\/www.excel-learn.com\/#\/schema\/person\/c3f75f86b1c65bf0b93fc46f629fcad3\"},\"description\":\"Go to Insert in the ribbon and click on \\u201cRecommended Charts\\u201d\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.excel-learn.com\/clustered-bar-charts-in-excel\/\"]}]},{\"@type\":[\"Person\"],\"@id\":\"https:\/\/www.excel-learn.com\/#\/schema\/person\/c3f75f86b1c65bf0b93fc46f629fcad3\",\"name\":\"excelmaster\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.excel-learn.com\/#personlogo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/e2a3743b4da71bd52984e02bd5c3280c?s=96&d=mm&r=g\",\"caption\":\"excelmaster\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","_links":{"self":[{"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/posts\/8997"}],"collection":[{"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/comments?post=8997"}],"version-history":[{"count":2,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/posts\/8997\/revisions"}],"predecessor-version":[{"id":9241,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/posts\/8997\/revisions\/9241"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/media\/8999"}],"wp:attachment":[{"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/media?parent=8997"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/categories?post=8997"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.excel-learn.com\/wp-json\/wp\/v2\/tags?post=8997"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}