I am working with Excel 2007 on Windows XP. For the last two days, I have been putting together some charts for which the data source is a query result table. Every time I save the workbook, close it and re-open it, the charts disappear. The page is still there, just nothing on it. If I change to view full screen, the chart comes back, but modified so that all of the data that was linked to the secondary axis is now all on one date all the way to the left, and there's no secondary axis. In addition, the primary axis labels are now bunched up in the middle of the chart. I have tried opening the charts in a different computer, but they are the same. I have tried copying and pasting the data table so that it is no longer a query table, but the same thing still happens.
Bookmarks