ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Deleting legend entries (https://www.excelbanter.com/excel-programming/317545-deleting-legend-entries.html)

Anat[_4_]

Deleting legend entries
 

Hi,

I encountered the following problem with chart legend entries:
I have several data series that should have few legend entries
therefore after I add to the chart a series that should not have
legend entry, I delete its legend entry. This works until I reach
large number of legend entries (29). At this point an error is raise
when the delete function of the legend object is called:
ActiveChart.Legend.LegendEntries(ActiveChart.Legen d.LegendEntries.Count).Delet


Is there a limit on the number of legend entries?
Is there a way to add some series with legend entries and other withou
legend entries?

Thanks,

Ana

--
Ana
-----------------------------------------------------------------------
Anat's Profile: http://www.excelforum.com/member.php...fo&userid=1670
View this thread: http://www.excelforum.com/showthread.php?threadid=31932


srparr

Deleting legend entries
 

either reduce the font or increase the size of the chart so that al
series are visible in the legend key. seemed to fix it for m

--
srpar
-----------------------------------------------------------------------
srparr's Profile: http://www.excelforum.com/member.php...fo&userid=1673
View this thread: http://www.excelforum.com/showthread.php?threadid=31932



All times are GMT +1. The time now is 11:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com