Try changing these lines Set Srs1 = ActiveChartSeriesCollection(1) Srs1Name = "Current State" Set Srs2 = ActiveChartSeriesCollection(2) Srs2Name = "Proposed Solution" To SeriesCollection(1)Name = "Current State" SeriesCollection(2)Name = "Proposed Solution"In this article Returns or sets a String value representing the name of the object Syntax expressionName expression A variable that represents a Series object Remarks You can reference using R1C1 notation, for example, "=Sheet1!R1C1" Support and feedback Bonus Tip Edit chart series data ranges using mouse If you have no time for writing lengthy formulas or setting up data tables, you can still save time when editing chart series data ranges Just select the series by clicking on the chart Now excel shows highlighted border around the cells from which the chart series is created
How To Add A Horizontal Line To The Chart Microsoft Excel 16
