What kind of chart are we talking about here? Do you mean the chart converts
from horizontal bars to vertical or something like that? Or does the actual
data switch in the series formulas?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Johannes" wrote in message
...
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.