Chart x-axis and name problem

I have a quite complex workbook in Excel 2007 with several charts, including
a xy scatter chart with 3 series. The number of points plotted has been
gradually increasing, and when it exceeded 185 on each series, the x-axis
(which is set to Auto for the minimum) suddenly switched to displaying 0 as
the minimum point, thus pushing the plotted area to the right of the chart. I
verified that if I exclude either the first or last point on the series, the
display is OK.

At the same time, all charts sheets lost their names, and became chart1,
chart2, chart3. Renaming them appeared to work, but on saving and reopening
the wrokbook this problem reappeared.

I have now set the minimum manually to the lowest value, which resolves the
first problem; after restarting Excel, the second problem now seems to have
gone away.

However all this looks like a bug, as the specificaions indicate that a data
series can contain up to 32,000 points. Any ideas?

--
Andrew B

I would be interested in seeing a sample file
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Andrew B" <andrew_burREMOVEnett.DeleteThis@compuNOSPAMserve.com> wrote in message
news:0CFEBCF3-373F-4CB5-A0B9-A2E62A8F52F9@microsoft.com...
> I have a quite complex workbook in Excel 2007 with several charts,
> including
> a xy scatter chart with 3 series. The number of points plotted has been
> gradually increasing, and when it exceeded 185 on each series, the x-axis
> (which is set to Auto for the minimum) suddenly switched to displaying 0
> as
> the minimum point, thus pushing the plotted area to the right of the
> chart. I
> verified that if I exclude either the first or last point on the series,
> the
> display is OK.
>
> At the same time, all charts sheets lost their names, and became chart1,
> chart2, chart3. Renaming them appeared to work, but on saving and
> reopening
> the wrokbook this problem reappeared.
>
> I have now set the minimum manually to the lowest value, which resolves
> the
> first problem; after restarting Excel, the second problem now seems to
> have
> gone away.
>
> However all this looks like a bug, as the specificaions indicate that a
> data
> series can contain up to 32,000 points. Any ideas?
>
> --
> Andrew B