I am managing a database of lab results for an external company. That compnay
recently upgraded from Excel 2003 to Excel 2007, which resulted in the
automatic swap of the x - and y - axis in all time - value graphs that are
inbeded in each worksheet of the database. I have labouriously reversed many
of the automatic changes, but still have a long way to go. However, the most
frustrating thing is that as soon as staff copy template worksheets, in which
the x - and y - axis have been corrected so that time is whown on the x -
axis and values on th y - axis, to enter data for a new product batch, the x
- and y - axis revert back the wrong way round. Trying to deal with this
problem caused by Excel 2007 has been one of the most frustrating work
experiences I have had for a very long time. Any ideas of what might help?
The other thing is that I can't try your suggestions striaght away, as,
luckily, I don't have Excel 2007; I can only try things, when I am working on
my client's system.