Download Excel Start File https//peoplehighlineedu/mgirvin/ExcelIsFun/ExcelDynamicChartsSeriesStartFilexlsDownload Excel Finished File https//p Step 1 Create two named ranges, one each for X Axis labels given in column A and one for data to be shown on the chart Y Axis To create the X Axis label, go to the Defined Names group on the formula tab and click on Define Name, give the name as XRange and select the range from the sheet To create the name range for Y Axis data series, go toTo add a named range, select the range of cells that you wish to name In this example, we've selected all cells in column A Then select the Formulas tab in the toolbar at the top of the screen and click on the Define Name button in the Defined Names group When the New Name window appears, enter a descriptive name for the range The name can
Dynamically Label Excel Chart Series Lines My Online Training Hub
