The following step by step approach is to show you example on Dynamic Chart Title by Linking and Reference to a Cell in Excel Linking Cell to make Dynamic Chart Title – Step 1 Select a Chart Title Identify the chart to link a cell reference to the chart title The following screenshot will show you example chart title is selectedAfter changing both Series Names, the final graph should look like this Change Chart Series Name in Google Sheets Similar to Excel, you can see the graph with the generic series names on the graph and a table To Change, Double Click on the Legend Name and make your changes for both Final Graph with Changes As you can see, the final graphI need to change the name Total, Cannot change through the "select

Excel Dynamic Chart Range Name Based On If Formula Not Accepted As Series Name Super User