Disappearing charts

[Guest]

I created Excel templates that contain tabular data and charts (pie, bar,
line mostly). The charts are populated with data I extract from a (SQL
Server) database and then load into pre-defined cell ranges. The users run a
VB6 application to generate the Excel reports. The issue I am having is that
users report that once the Excel file is created, the charts disappear when
the file is reopened. I have seen this result first hand as well. The data
that supports the chart is still there, but the charts themseleves disappear.
I actually recreated the template from scratch thiniing that the .XLT file
might have gotten corrupted somehow. This seemed to resolve the problem, but
now the issue has surfaced again. I did an exhaustive search of the web and
was unable to find anyone with the same or a similar problem. Users are
running Windows 2000 (SP4) and Excel 2000.

 

[Guest]

Do you leave the charts in place and just delete the cells before putting the
new data in? If so, as soon as you delete the cells, the charts lose their
link to the data series. If the number of rows / columns being charted does
not change you should be able to just drop in the new values without deleting
first. Otherwise you have to go through the chart objects and respecify the
data series. Can sometimes be a problem since I have found it difficult to
get rid of the old ones first, if they have already lost the links.