Excel Chart Legend Name

D

David

Does anybody know how to name a Legend within an Excel Chart created within
Access?

Code sample below:

xlChart.HasLegend = True

.... but, there seems to be no NAME property to assign...

Any ideas?
 
V

Van T. Dinh

The collection is LegendEntries and each item is LegendEntry ...

Example from Help:

myChart.Legend.LegendEntries(1).Font.Name = "Arial"
 
D

David

Got that one.

Was looking for more of a Label or Caption to be above the values of a
Legend. For example, the title: "Assignees".
 
V

Van T. Dinh

Not sure which element you described ... "Assignees" has meaning in your
chart but I cannot see your chart ...

ChartTitle ???
DataLabels / DataLabel ???
LegendKey ???
 
Top