how to make a pie chart in excel with two column of data

HOW TO MAKE A PIE CHART IN EXCEL WITH TWO COLUMN OF DATA SERIES
HOW TO MAKE A PIE CHART IN EXCEL WITH TWO COLUMN OF DATA DOWNLOAD

A new window will pop up with the name Axis Labels. Step 8: Click on the Edi t button under the Horizontal (Category) Axis Labels section. This is the one where you need to edit the default labels so that we can segregate the sales values column Country wise. Now, if you see at the right-hand side, there is a Horizontal ( Category) Axis Labels section.

HOW TO MAKE A PIE CHART IN EXCEL WITH TWO COLUMN OF DATA SERIES

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 Series name and C2:C7 as a reference for Series values. Follow the same procedure as of the previous step. Step 7: Click on the Add button one more time to be able to add the values associated with Sales 2019. NOTE: You can add Sheet 1 or Sheet 2 under Series Value.Īs soon as you click OK, you can see behind the Select Data Source window the bars are being added for the Sales Value 2018 column. Step 6: Under 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 the year 2018 associated with different countries. Under Series Name: select the B1 as an input (since B1 contains the name for sales value 2018. Step 5: As soon as you click on the Add button, a new window will pop up named “Edit Series”. Step 4: Click on the Add button placed at the left-hand side of the Select Data Source window. Under Legend Entries ( Series) inside the Select Data Source window, you need to select the sales values for the year 2018 and year 2019. This window helps you modify the chart as it allows you to add the series (Y-Values) as well as Category labels (X-Axis) to configure the chart as per your need. Step 3: As soon as you click on the Select Data option, a new window “Select Data Source” will open up in Excel as shown below:

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 so that we can 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 on Insert Column or Bar Chart dropdown and then 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.

HOW TO MAKE A PIE CHART IN EXCEL WITH TWO COLUMN OF DATA DOWNLOAD

From the Chart Tools, Layout tab, Current Selection group, select the Vertical (Value) Axis.You can download this Comparison Chart Excel Template here – Comparison Chart Excel Template.Make sure that the chart is still selected.In the dialog box under Horizontal (Category) Axis Labels, click Edit.From the Design tab, Data group, select Select Data.From the Chart Tools, Layout tab, Current Selection group, select the Horizontal (Category) Axis.Make sure that you select the headings as well as the data before you create your chart. In the Series name box, enter the cell reference for the name of the series or use the mouse to select the cell, click OK.Īrrange your data so that headings are directly above and to the left of the data to be charted.In the dialog box under Legend Entry Series, select the first series and click Edit.

In the Axis label range enter the cell references for the x-axis or use the mouse to select the range, click OK.

In the Select Data Source dialog box under Horizontal (Category) Axis Labels, click Edit.

There should be no blank rows or columns. 264How can I make an Excel chart refer to column or row headings?Īrrange your data so that headings are directly above and to the left of the data to be charted.

How to make a pie chart in excel with two column of data