user to input date as "yyyy" in cell
in [Programming]
|
Prev: To get the same header,footer and sheet titles across multiple she
Next: Automatically Sorting of Excel Records
From: David on 24 Feb 2010 03:08 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?
From: joel on 24 Feb 2010 04:52
The chart will use the same format as the cells it is referencing. so if you change the format of the cells where the dats are located the x axis on the chart ill also change. Now if you need to have the cells in one format and the chart in another format then you have to create a new table on the worksheet and have the chart refere to the new table. You caqn have the old table and new table linked by making the new table a formula. If your old table is A1:D10 then make a new table at G1:J10 and put the formula =A1 at G1. Then copy the formula to G1:J10 and have then format the two tables so one shows the entire date and the 2nd just the year. -- joel ------------------------------------------------------------------------ joel's Profile: 229 View this thread: http://www.thecodecage.com/forumz/showthread.php?t=182104 [url="http://www.thecodecage.com"]Microsoft Office Help[/url] |