Programmably Change a Chart Legend

[Daveyk01]

The column of the datasheet could represent a different variable depending how much data was collect for a given function.

I find the colum titles make up the ledgend.

So I just need to know how to change the datasheet column title through programming.

I have tried something like this that does not work:
objDataSheet("B0").value = "LP"

This doesn't work either:
objDataSheet("B").value = "LP"

Thoughts please?

Thanks kindly

Dave

Liittle rusty on chart programming after being a way for a few years.