![]() Click on Column and select 2-D Clustered Column Chartįigure 3.Click on Insert tab and go to Charts section.We select the data table B1: D7 and create the 2-D chart in Excel 2010 and earlier versions by following these steps Suppose we have monthly revenue and profit margin data series in terms of dollar amounts and percentages in a table range B1:D7.įigure 2. But when the values of data series vary then we can plot more than one data series on secondary axis Excel. We can create one data series at a time on a secondary axis. How to Add Secondary Axis in Excel Using Excel 2010 and Earlier Versions ![]() We will learn how to add secondary axis in Excel based on following versions įigure 1. Excel secondary axis allows us to show two Y-axis data series with two different scales using the same X-axis. When we have two different yet related pieces of information then we need to show them on Y-axis on a single chart. How to Add Secondary Axis in Excel and Google Sheets
0 Comments
Leave a Reply. |