M
Marc Reinig
I have two charts. In one, when I go to "format axis" I can enter the min
and max scale as dates and the entry remains as dates when I come back. I
can also set the "base unit" a major and minor grid line in days, weeks,
months, etc.
The second chart, I do not have a base unit drop down box, and although I
can enter dates in the max and min in date format and they work, when I come
back the entries are in days since the start of time (38353 in 1/1/2005)
And I cannot specify the units of major and minor grid lines, they are just
units. Which makes it awkward for minor girdlines on months.
I have looked all over the place and can't figure out how to change the
second spread sheet to act like the first.
Thanks in advance,
Marc Reinig
System Solutions
and max scale as dates and the entry remains as dates when I come back. I
can also set the "base unit" a major and minor grid line in days, weeks,
months, etc.
The second chart, I do not have a base unit drop down box, and although I
can enter dates in the max and min in date format and they work, when I come
back the entries are in days since the start of time (38353 in 1/1/2005)
And I cannot specify the units of major and minor grid lines, they are just
units. Which makes it awkward for minor girdlines on months.
I have looked all over the place and can't figure out how to change the
second spread sheet to act like the first.
Thanks in advance,
Marc Reinig
System Solutions