Hi, I input the following for the chart title ='Project Hours'!$B$1 works perfectly but I need to add text before that says Project Hours For ---the date its filtered for or 'Project Hours'!$B$1---- Any thoughts? Thanks Solution: Pivot table: Add Chart Title - Dynamic by Filter sorry: ="Project Hours For"& " " &TEXT(C7;"dd/mm/yyyy") jppinto Active Roaming Profile/Temporary Internet Files Domain Controller not responding SBS 2008 Internet Address Management Wizard & 'Fix my Network wizard' fails, fresh install PSEXEC Help Need to call stored procedure but define its name Excel Array works for row, but can't change to column dd/mm/yy How do I save results from sp_helpfile on each databases into single table MSSQLSERVER event ID 19019 Passing "inserted" and "deleted" rows from trigger to stored procedure