>Hilmar
>
>I regard you as the VFP /Excel expert...
This, I am definitely not. But I will see if I can help.
> ... - here's one for you
>
>My axis currently reads
>Jan 03
>Feb 03
>etc to
>Dec 03
>
>I want it to read
>Jan 04
>Feb 03
>etc to
>Dec 03
>
>How do I do it
Several ideas come to mind. In Excel, you could:
Edit each field (F2, if you do it manually in Excel), erasing the last character ("3") and replacing it with "4".
Use search and replace.
Insert each value manually (typing the entire value).
The last option seems to me the simplest to implement with Automation:with .oSheet
.Cells(1,1).Value = "Jan 04"
.Cells(1,2).Value = "Feb 04"
...
endwith
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)