Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide zero entries from legend | Charts and Charting in Excel | |||
Legend entries into columns | Charts and Charting in Excel | |||
Legend Entries | Charts and Charting in Excel | |||
Specifying Legend Entries | Charts and Charting in Excel | |||
Why 2 legend entries? | Excel Programming |