Yes, you can make a tab name the chart title in Excel. Here's how:

1. Click on the chart to select it.
2. In the Chart Tools menu, click on the "Layout" tab.
3. In the "Labels" group, click on "Chart Title" and select "Above Chart" or "Centered Overlay" depending on your preference.
4. Click on the "Chart Title" text box that appears on the chart and type in the formula
   Formula:

   "=Sheet1!A1" 

   (replace
   Formula:

   "Sheet1" 

   with the name of your sheet and
   Formula:

   "A1" 

   with the cell that contains the tab name).
5. Press Enter and the chart title will now display the name of the tab.

If you want to make this process easier, you can create a named range for the tab name and use that in the formula instead of the cell reference. Here's how:

1. Select the cell that contains the tab name.
2. In the "Formulas" tab, click on "Define Name" in the "Defined Names" group.
3. Type in a name for the range (e.g.
   Formula:

   "TabName" 

   ) and click "OK".
4. In the chart title formula, replace the cell reference with the named range (e.g.
   Formula:

   "=TabName" 

   ).
5. Press Enter and the chart title will now display the name of the tab.