| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| add legend to chart | Charts and Charting in Excel | |||
| Legend on Chart | Charts and Charting in Excel | |||
| Bar Chart Legend Key | Charts and Charting in Excel | |||
| Chart Legend | Charts and Charting in Excel | |||
| pie chart legend | Charts and Charting in Excel | |||
Threaded Mode
