Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disappearing charts
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. -- Dave G |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disappearing charts
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. -- Martin Harmelin "Dave G" wrote: 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. -- Dave G |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Disappearing Excel Charts | Charts and Charting in Excel | |||
Disappearing Charts | Charts and Charting in Excel | |||
Charts disappearing | Charts and Charting in Excel | |||
Disappearing/Greyed Charts | Charts and Charting in Excel | |||
Charts and Graphs disappearing | Charts and Charting in Excel |