You have lots of tabs in your Excel ... is to create a dashboard tab. Click the "+" symbol next to your tabs and rename it Dashboard. You want this to be the first sheet in your workbook, so ...

Revert the workbook to the last saved version ... X.Name With Worksheets("ChartData") To execute the macro, create a new sheet in the Excel file. Then select the chart, and run the macro.

Before LAMBDA was introduced to Excel, you'd need to know how to use VBA or macros to create your own function. However, ...