How to get a comparison product chart in Excel 365?
Tags: togetacomparisonprod
Published: 2021-08-17 03:43:53

---
title: How to get a comparison product chart in Excel 365?
published: true
date: 2021-08-11 16:37:38 UTC
tags: ToGetAComparisonProd
canonical_url: https://geekexcel.com/how-to-get-a-comparison-product-chart-in-excel-365/
---

A **comparison chart** is a **graphical representation** of different **informational values** associated with the same **set of categories** , which can be compared for different geographical regions or for different categories, etc. In this post, we will explain to you how to **get a Comparison Product Chart In**  **Excel Office 365.** Let’s see them below!! Get an official version of MS Excel from the following link: **[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

## Create Clustered 2D chart

- Firstly, you have to **enter the data** in the Excel spreadsheet.
- For instance, we have created **visitors details**.

![](https://geekexcel.com/wp-content/uploads/2021/08/visitors-detail-3.png)<figcaption>Visitors detail</figcaption>

- Then, you need to **select the data** and go to **Insert tab**.
- Now, you have to select any **clustered 2D chart** under the **chart** section.

![](https://geekexcel.com/wp-content/uploads/2021/08/select-the-chart-type-1024x562.png)<figcaption>Select the chart type</figcaption>

- After that, you will get a **chart** having a chart representing **3 datasets** with **indices 1 to 10 in the vertical axis**.

![](https://geekexcel.com/wp-content/uploads/2021/08/clustered-2D-chart-1024x489.png)<figcaption>Clustered 2D chart</figcaption>

- You need to **right-click** on **chart** and click  **Select data**  option.

![](https://geekexcel.com/wp-content/uploads/2021/08/Click-on-Select-Data-2-1024x719.png)<figcaption>Click on Select Data</figcaption>

- Then, you need to select **Year ** from the Bars and click the  **Remove ** button to remove it.

![](https://geekexcel.com/wp-content/uploads/2021/08/remove-the-year.png)<figcaption>Remove the year</figcaption>

- Now, this will **remove the little blue bars** from the chart as shown below.

![](https://geekexcel.com/wp-content/uploads/2021/08/remove-the-blue-bar-1024x481.png)<figcaption>Final output</figcaption>

- You need to **edit the indices with year values** and select the **Edit** button.

![](https://geekexcel.com/wp-content/uploads/2021/08/Click-on-Edit-button.png)<figcaption>Click on the Edit button</figcaption>

- After that, clicking the **Edit button** , you will receive an  **Axis labels**  dialog box asking for the **new range to replace** with indices.
- For that, you have to **select the year range** from the data.

![](https://geekexcel.com/wp-content/uploads/2021/08/type-the-axis-label-1024x489.png)<figcaption>type the axis label value</figcaption>

- After that, you need to click the **OK** button to get the modified chart with year value.

![](https://geekexcel.com/wp-content/uploads/2021/08/click-ok-1024x496.png)<figcaption>Click OK button</figcaption>

- Then, you have to **edit the horizontal axis** by **double-clicking** the axis, it will **open a Format axis panel** in the right of the chart.

![](https://geekexcel.com/wp-content/uploads/2021/08/format-axis-1024x533.png)<figcaption>Open Format Axis</figcaption>

- To show the **range in millions** you have to select the  **Display units ** to  **millions ** from  **None**.

![](https://geekexcel.com/wp-content/uploads/2021/08/select-display-units-1024x545.png)<figcaption>Select the Display unit</figcaption>

- Now, you need to **edit the Bars Width and gap Width** between the **bars** by fixing the  **Series Overlap ** and  **Gap Width percentage**.
- For that, in the **format data series** option, you have to select the  **Primary Axis**  option from the  **Series** Options.

![](https://geekexcel.com/wp-content/uploads/2021/08/click-on-primary-axis-1024x534.png)<figcaption>Click on Primary Axis</figcaption>

- Finally, you can see the **Bars Width and Gap Width** are adjusted according to chart size.

![](https://geekexcel.com/wp-content/uploads/2021/08/final-output-for-axis-1024x496.png)<figcaption>Adjusted chart size</figcaption>

## Wrap-Up

Hope you understood how to **get a Comparison Product Chart In**  **Excel Office 365**. Please feel free to state your query or feedback for the above article. Thank you so much for Reading!! To learn more, check out **[Geek Excel](https://geekexcel.com/)!! **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

**Read Also:**

- **[How to Create a Year Over Year Comparison Bar Chart in Excel?](https://geekexcel.com/how-to-create-a-year-over-year-comparison-bar-chart-in-excel/)**
- **[Excel Formulas to Lookup the Cost for the Product or Service!!](https://geekexcel.com/excel-formulas-lookup-the-cost-for-the-product-or-service/)**
- **[Excel Formulas to Get Location of Value in 2D Array!!](https://geekexcel.com/excel-formulas-get-location-of-value-in-2d-array/)**
- **[Creating Quarterly Sales Chart by Clustered Region in Excel 365!!](https://geekexcel.com/creating-quarterly-sales-chart-by-clustered-region-in-excel-365/)**