![]() 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. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |