with a scatter graph, you should be able to change the minimum value for
your x axis
in a line chart you should be able to set up a series saying "pre", "1900",
"1905" etc at the appropriate spacing and select them as your catagory X
axis labels.
<Chart<Source data<Series
Aha after reading your response again you already have done this. in your
line with pre 1900 1901 etc delete the ones which do not end in 0 or 5
and select a catagory spacing of 1 if you want the same spacing between the
pre and 1900, add some cells between the pre and 1900
"afsarul" wrote:
Thank you for the reply. I'm not sure if I understood you clearly, but
the method you suggested for me would not be valid, since the 'pre-'
label contains significant data that I cannot ignore.
Maybe to explain myself a bit more. I have a data range that starts at
'pre-' and ends at '2025'. The interval is yearly i.e pre-, 1900, 1901,
1902, 1903...2025 (with the exception of the 'pre-' which is data summed
from years preceding 1900). I would like the x-axis to read pre-, 1900,
1905, 1910, 1915 ... 5 years ..., 2025. Instead it reads pre-, 1904,
1909, 1914, 1919 .... 5 years .... 2024. It doesn't change whether its
a line or scatter and the category spacing is at 5.
Still your help is appreciated, my Masters is seemingly hanging on this
trivial issue.
Regards,
Saad
--
afsarul
------------------------------------------------------------------------
afsarul's Profile: http://www.excelforum.com/member.php...o&userid=24203
View this thread: http://www.excelforum.com/showthread...hreadid=378166