将一系列文本放在图表工作表的页脚中

I have text in cells N27:N30 and I would like that text to be copied into a footer on my chart sheet. Would anyone know if and how this can be done? I'm not familiar with how footers are created using VBA...Thank youI have text in cells N27:N30 and I would like t