Thread: Set Legend of a Chart from VBA?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike B in VT Mike B in VT is offline
external usenet poster
  
Posts: 4
Default Set Legend of a Chart from VBA?
I'm trying to set the Legend caption of a Chart by referencing a cell in a
different sheet but

ActiveChart.Legend.LegendEntries(1) =
ActiveWorkbook.Sheets("Sheet2").Range("F2").Value

gives me "Object doesn't Support this property or method".

Is there anyway to do this?

Reply With QuoteReply With Quote