After that, click on the Chart Title as marked in the following image.After that, choose your preferred style.Īfter selecting the style, you will be able to see that the chart has been formatted with your preferred style.Īt this point, Data Labels will be added to the chart like the following picture.First, click on the paintbrush icon as marked in the following image.Go to the Insert tab > Insert Column or Bar Chart dropdown > Clustered 2-D Column option.Īfter that, a Clustered Column Chart should be visible on your screen like the below-given image.Īt this stage, we are going to format our chart to give it a better look and visibility.After that, your dataset should be looking like the following image. Similarly, add another blank row over the city of Houston. After that, go to the Home tab > Insert dropdown > Insert Sheet Rows option.Īfter that, you will be able to see the following picture on your screen.Here cell C7 represents Salt Lake City in the state of Utah. Then, your dataset should be looking like this. Similarly, for the other two states, we can follow the same procedure and merge them. Then, from the Alignment group choose Merge & Center.Īfter selecting Merge & Center, you will be able to see the following image on the screen.Īfterward, you will be able to see that the two cells are merged together.So, firstly, select two cells of Arizona. If we look carefully, we can see that there are a total of 3 states in the 6 columns.We will make a Comparison Chart of Sales among different States. In the following dataset, we have sales data of ABC company for different states and cities.
Applying Clustered Column Chart to Make a Comparison Chart in ExcelĬlustered Column Chart is one of the most popular methods of creating a Comparison Chart. We have used Microsoft Excel 365 version for this article, you can use any other version according to your convenience.ġ. After learning these methods, you will be able to create both simple and advanced Comparison Charts in Microsoft Excel. In this article, we are going to learn 4 simple methods to make a Comparison Chart in Excel. Fo this reason, a Comparison Chart is a highly efficient way of visualizing datasets.Ĥ Ways to Make a Comparison Chart in Excel And all of this can be done without going through the long, tedious datasets. With the help of a Comparison Chart, we can easily visualize our data along with their trends, correlations among different parameters, etc. As the name refers, a Comparison Chart is such a kind of chart where we can compare two or more different kinds of data and understand various correlations among them.
0 kommentar(er)
