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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top