Home |
Search |
Today's Posts |
#1
|
|||
|
|||
dates start at 01 January 1900
Hi. I'm trying to create a line chart with the x (category) axis showing time. If I open Chart Options and select Automatic for the x axis, the dates start at 01 January 1900, ignoring my date data. But if I choose Time-scale (in Chart Options), the x axis is O.K. (it uses my values), but all my Y values vanish completely, so that the chart is blank. Any ideas would be appreciated. :( Thanks. -- melo ------------------------------------------------------------------------ melo's Profile: http://www.excelforum.com/member.php...o&userid=26784 View this thread: http://www.excelforum.com/showthread...hreadid=400394 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dates earlier than 1900 | Excel Discussion (Misc queries) | |||
Find project start and end dates in a DB with many different proje | Excel Worksheet Functions | |||
Where is DateDiff function in Excel 2002 ? | Excel Worksheet Functions | |||
Need to sort dates before 1900 in proper order | Excel Discussion (Misc queries) | |||
Inserting Blank Rows Macro? | Excel Worksheet Functions |