Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
user to input date as "yyyy" in cell
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
user to input date as "yyyy" in cell
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/sh...d.php?t=182104 Microsoft Office Help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel VBA to convert "dd.MM.yy" text to "dd/MM/yyyy" format date? | Excel Programming | |||
Convert text "date" (DDMMMYY) to datetime value of YYYY-MM-DD - ho | Excel Discussion (Misc queries) | |||
Using "dd/mm/yyyy h:mm" on Date Variables | Excel Programming | |||
Option Explicit and Date Format "dd mmm yyyy"? | Excel Programming | |||
How To: Use Cell("Format") to return MMMM YYYY instead of D3 | Excel Programming |