Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
legendentries
The following code applied to an embedded chart in a chartsheet fails with
error message 'Unable to get the Legendentries property of the Legendclass'. Error # 1004. For Each le In ActiveChart.Legend.LegendEntries le.LegendKey.Border.LineStyle = xlNone Next Any idea why? ojv |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
legendentries
Are you sure your chart has a legend,
If ActiveChart.HasLegend Then Regards, Peter T The following code applied to an embedded chart in a chartsheet fails with error message 'Unable to get the Legendentries property of the Legendclass'. Error # 1004. For Each le In ActiveChart.Legend.LegendEntries le.LegendKey.Border.LineStyle = xlNone Next Any idea why? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
legendentries
It worked fine for me. What type of chart are you working with?
-- Regards, Tom Ogilvy "ojv" wrote in message ... The following code applied to an embedded chart in a chartsheet fails with error message 'Unable to get the Legendentries property of the Legendclass'. Error # 1004. For Each le In ActiveChart.Legend.LegendEntries le.LegendKey.Border.LineStyle = xlNone Next Any idea why? ojv |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
legendentries
I'm trying it on a surface contour chart.
"Tom Ogilvy" wrote: It worked fine for me. What type of chart are you working with? -- Regards, Tom Ogilvy "ojv" wrote in message ... The following code applied to an embedded chart in a chartsheet fails with error message 'Unable to get the Legendentries property of the Legendclass'. Error # 1004. For Each le In ActiveChart.Legend.LegendEntries le.LegendKey.Border.LineStyle = xlNone Next Any idea why? ojv |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
legendentries
The Legend box needs to showing.
ActiveChart.HasLegend = True -- Rob van Gelder - http://www.vangelder.co.nz/excel "ojv" wrote in message ... I'm trying it on a surface contour chart. "Tom Ogilvy" wrote: It worked fine for me. What type of chart are you working with? -- Regards, Tom Ogilvy "ojv" wrote in message ... The following code applied to an embedded chart in a chartsheet fails with error message 'Unable to get the Legendentries property of the Legendclass'. Error # 1004. For Each le In ActiveChart.Legend.LegendEntries le.LegendKey.Border.LineStyle = xlNone Next Any idea why? ojv |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|