Hello
I know how to create a simple dynamic chart title. BUT is this possible?

Title for dynamic chart is
Report for (month, which is always the previous month)
Rate (comes from worksheet entitled Monthly, column H, depending on the
month )
I'm always a month behind so my chart title created in august reads

Report for July 2008 ( next line )
Rate 94.25%

(On the monthly tab I have a report with all 12 months and each month I
add the results . )
so next month I want the title to be
Report for August 2008 ( next line )
Rate (whatever) Is this possible? thanks in advance