how to plot a graph in excel with two x axis

#How to plot a graph in excel with two x axis update
#How to plot a graph in excel with two x axis series

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 plot a graph in excel with two x axis 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 plot a graph in excel with two x axis update

Once, you add the new data and click OK, you will be able to see the update labels reflecting the new data.You can download this Comparison Chart Excel Template here – Comparison Chart Excel Template If you have chronological data, you can directly access the labels. Our goal is to change the x-axis so that you can delete the x values and replace them with the new values. Once you choose Select Data, an Edit Series window will open with information on the axis.

In the options window, navigate to Select Data to change the label axis data. Right-click the graph to options to format the graph. Our goal is to replace the X axis with data from Date Column. From the image below, you can see that this graph is based on the index column and the Selected Period column. But essentially the steps are the same.įollow the visuals instructions below or watch the video:Ĭreate a graph. Also, you can directly change x values from Select Data Source window. For categorical data, you don’t need to worry about this. However, if you graph is chronological or time series based you need to pick a complementary chronological data. However, you still can by simply clicking Edit Legend Series and choosing X values. The Edit Series window will open up, then you can select a series of data that you would like to change.įor a time series like months, when you click select data you will not have the option to directly edit the x-axis.

Right-click the axis you want to change and navigate to Select Data and the Select Data Source window will pop up, click Editģ. Select the Chart that you have created and navigate to the Axis you want to change.Ģ. Be more efficent and accomplish more with Excel Beginner to Advance Course up to 90% discount from this link.ġ. You can also create a new set of data to populate the labels. You will add corresponding data in the same table to create the label.

The procedure is a little different from the previous versions of Excel 2016. Often there is a need to change the data labels in your Excel 2016 graph.