Hi,

Maybe rather than a template you should write a macro that creates the chart
automatically from scratch every time, this would eliminate the problem.

--
Thanks,
Shane Devenshire


"rdemyan" wrote:

I have created an Excel template with a maximum number of 10 series.
The worksheet is populated with series data from an Access application.

Everything works fine in terms of getting the data from Access to Excel
and then having the chart created.

The problem is that if 9 or fewer series are sent to the template, the
Legend still shows all ten series even though the chart shows only the
actual number of series. The "extra" series shown in the Legend do not
have a name.

I want to remove these 'extra' series from the Legend. I think it
would be easier to do this within the Excel template than to try to do
this from MS Access. In the Chart_Activate procedure

I tried looking for .SeriesCollection(i).Name = "" or
IsNull(.SeriesCollection(i).Name), but errors are generated in both
cases.

Then I thought, why not just trap the error and delete the unnamed
Legend item in the error handler using:
ActiveChart.Legend.LegendEntries(i).Delete

This actually worked, UNTIL, I activated the chart a second time. Then
I started getting an error because apparantly the series count actually
is ten even though only the number of series actually sent from Access
are charted.

Any thoughts on how I can reset the legend in the Excel template to
only display the actual number of series that are being plotted (even
though the template is set up to display ten).

Thanks.