Trying to graph on the x-axis with dates, x-axis is linked to a cell whose formula is
=TEXT(Oct!AE154,IF(ISNUMBER(Oct!AE154),"mm/dd/yyyy",""))
and is linked to cells in which dates will be entered,
Graph's x-axis returns 1/0/1900 for all blank cells, is there a way I can stop this from happening and have the axis auto-populate as data is entered?
Last edited by NanaNanaBatman; 10-06-2011 at 04:44 PM. Reason: clarity
edited for clarity
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks