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:

Create line chart in excel for mac