user to input date as "yyyy" in cell

D

David

I have a time series chart feeding off user input data. The data and chart
are dates (eg: 01/01/2007 00:00:00) displayed as years (eg: 2007). I need
the chart x-axis to remain as a time series.
The user perceives that the cell contains "2007".
Is there a way to enter just "2007" (4 characters only) and obtain a
date/time for the year 2007 in a cell?
 
J

joel

The chart will use the same format as the cells it is referencing. s
if you change the format of the cells where the dats are located the
axis on the chart ill also change. Now if you need to have the cells i
one format and the chart in another format then you have to create a ne
table on the worksheet and have the chart refere to the new table. Yo
caqn have the old table and new table linked by making the new table
formula.


If your old table is A1:D10 then make a new table at G1:J10 and put th
formula =A1 at G1. Then copy the formula to G1:J10 and have then forma
the two tables so one shows the entire date and the 2nd just the year.
 
Top