I know this is a bit of a late reply, even so, thank you Jon and BJ.
Everything did work out fine. BUT, I'm stuck again. All that time I was
using a line chart for plotting, but my supervisor has asked me to
switch to XY scatter. When I do this, the X-axis loses the pre-, 1900,
1905, 1910, ... 2025 year format and displays 0, 5, 10, 15 ... 140
instead. I'm sure there is a simple solution which you know, but as I
understand it the 'pre-' label is the problem again. If I exclude the
'pre-' data the graph axis reverts to a 1900, 1905, 1910 etc format.
Even with [=1895]"pre-";0 the axis oddity still occurs.

Thank you dearly,

Saad


--
afsarul
------------------------------------------------------------------------
afsarul's Profile: http://www.excelforum.com/member.php...o&userid=24203
View this thread: http://www.excelforum.com/showthread...hreadid=378166