Two Axis Chart

Most of the time we are using the option excel charts to interpret our data in an organized manner. However we are not using or not known to use two axis charts to do so. Following steps describing this post you can easily create two axis chart in Microsoft Excel. The data in this post are also extracted from a fresh fruit merchant who described in a previous post. Please download the data file using this link from google drive.

Select the range A1:C4.

Click on charts group in inserts tab & select line graph format from it.

This section gives you the basic chart like below.

Select buying price series & right click on it.

Select "Format Data Series" from pop up menu.

Now you can see the pop up window like this.

Select "Secondary Axis" option from that window & click close.

Now you have the two axis chart.

Select "Layout" tab from Chart tools & make any changes you like.

Then final chart will be below.