Suppose you have the following data set of Sales and Profit margin of a company for six years.īelow is the chart that I have created using this data. Let me try and explain this by using an example. Why Add a Secondary Axis in Excel Charts?
Adding the Secondary Axis Manually (2013 and above versions).Why Add a Secondary Axis in Excel Charts?.