Please note that there is no such option as Comparison Chart under Excel to proceed with. You can see the chart as shown in the screenshot below: Step 9: Click the OK button again to close the Select Source Data window, and you are through. Click on the OK button after you select the ranges. Under the Axis label range: select the cells that contain the country labels (i.e., A2:A7). A new window will pop up with the name Axis Labels. Step 8: Click the Edi t button under the Horizontal (Category) Axis Labels section. Here you must edit the default labels to segregate the sales values column Country wise. Now, on the right-hand side, there is a Horizontal ( Category) Axis Labels section. You can see these two series get added under the Select Data Source window: It should look as shown in the screenshot below: Use C1 as a reference for the Series name and C2:C7 for Series values. Follow the same procedure as in the previous step. Step 7: Click the Add button again to add the values associated with Sales 2019. When you click OK, you can see behind the Select Data Source window the bars are being added for the Sales Value 2018 column. NOTE: You can add Sheet 1 or Sheet 2 under Series Value. Step 6: Under the Series Values: section, delete “=,” which is a default value for a series, and then select the range of cells that contain the sales values for 2018 associated with different countries. Under Series Name: select B1 as an input (since B1 contains the name for sales value 2018. Step 5: When you click the Add button, a new “Edit Series” window will appear. Step 4: Click on the Add button placed on the left-hand side of the Select Data Source window. Under Legend Entries ( Series), inside the Select Data Source window, select the sales values for 2018–2019. This window helps you modify the chart by allowing you to add the series (Y-Values) and Category labels (X-Axis) to configure the chart as per your need. Step 3: Once you click on the Select Data option, a new window, “Select Data Source,” opens in Excel: Step 2: Select the graph by clicking on it and navigate to the Design tab click on the Select Data option under the Data section. Now, we need to add Data to this blank chart to see the sales values for countries in a comparative manner. This step will allow you to add a blank chart layout, as shown in the screenshot below. Under the Charts section, click Insert Column or Bar Chart dropdown and select the Clustered Column Chart option under the 2-D Column Chart section. Step 1: Select the Insert tab through the Excel ribbon and then navigate to the Charts section. You can download this Comparison Chart Excel Template here – Comparison Chart Excel Template Now, let’s explore how to create a comparison chart in Excel using sales data associated with different regions, as depicted in the screenshot below.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |