Excel Chart Legend Name

[Guest]

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?

 

[Van T. Dinh]

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

Example from Help:

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

 

[Guest]

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".

 

[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 ???