I hope someone can help me with this. I havent found any positive research, but it doesnt make sense. I have these great charts, but when I open the workbook in the wee hours of the night, something terrible happens...the formatting of the data is lost.
Some few nights ago (I think it was a full moon) I decided to take a very large workbook and divide it up into separate workbooks. This resulted in five "sub" workbooks of considerable size with vast amounts of data particular to each unique workbook within. I also wound up with one unique workbook- a book to hold all the charts for the others unique data books. This book was linked to the data.
Now, these charts have graphics to be proud of, but some have table data as well. That was when I first noticed something was wrong. The charts themselves seem to bring over the formatting fine, at least along the y axis, but the table data becomes a number/serial version of any data that is a percentage or date- not the original defined data format. They have "changed" somehow.
The next day I reopened the main chart workbook and the associated "sub" workbooks and alas! It was fine again! The formatting was back to normal. It was the chart I knew and loved.
This must be some kind of a werechart, because every night it resumes its grotesque form, hideous and vile, while in the light of day they are the charts I love and adore again.
Can someone help me restore my charts to their rightful form? Why do they keep changing formats in this manner? Why is the y axis always fine? How can I take a considerable amount of charts associated with many linked workbooks and present them in an intelligent, sensible manner?