I have written a VBA code to create a graph, since my row count is >32000
rows, I created a second series collection for rows 32000 to 64000. I have
formated the seriescollection so it looks like 1 series. When I try to remove
the legend entry using
ActiveChart.Legend.LegendEntries(x).Select
Selection.Delete
it works on my computer and about 90% of the others, but not on about 10% of
the computer, it appears there is a problem with .legend.legendentries on
some computers.
I have found using .seriescollection there were workarounds for other legend
issues, is there a way to remove the entry using .seriescollection(x).
Jon Peltier - 23 Feb 2007 04:02 GMT
Unfortunately the legend entries are completely divorced from the
seriescollection in the object model.
Can you shorten the two lines into one:
ActiveChart.Legend.LegendEntries(x).Delete
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______
>I have written a VBA code to create a graph, since my row count is >32000
> rows, I created a second series collection for rows 32000 to 64000. I
[quoted text clipped - 12 lines]
> legend
> issues, is there a way to remove the entry using .seriescollection(x).