Excel 2007 : Display Sheet Name in Workbook

**physicsstinks** · 12-15-2010, 06:00 PM

Is it possible to display the sheet name within the workbook? For example I keep my budget on excel and would like to display the sheet name above all my charts. Each sheet is labeled with the month and I want to place that name above all the charts in the sheet.

Thanks for your help.

**TMS** · 12-15-2010, 07:08 PM

=MID(CELL("Filename",A1),FIND("]",CELL("Filename",A1))+1,255)

Note that the workbook must have been saved or you will get a #VALUE! error

Regards

**physicsstinks** · 12-15-2010, 08:00 PM

Works like a charm. Thanks so much!

**physicsstinks** · 12-16-2010, 05:46 PM

Along the same line of questioning. Is it possible to use the sheet name for the title of a pivot chart. Basically can you use a formula for the chart title. If not is there a workaround. Thanks for the help.

**TMS** · 12-16-2010, 06:16 PM

Click in the title within the chart (if you don't have one you need to add one first) and then click in the formula bar. Then enter "=Sheet1!A1" without the quotes, where cell A1 on Sheet1 contains the name you want to appear as the title. And, in this case, cell A1 contains the sheet name from the previous question.

Regards