| 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 | |
|
|
![ojv[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
