VBA to set the Source Data of a Chart as a Variable

[eoinymc]

Hi,

I was wondering if it is possible to set the source data in a chart as a variable?

Or even just display it in a msgbox?

I tried to do MsgBox cht.SetSourceData.Source
but that obviously didn't work as I believe that is how you set the source...

Anyone have any ideas for me?

Thanks,

Eoin