If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
specify date source for x-axis (adjacent to data column in Excel)
MS Excel 2002: From a column of dates and an adjacent column of dollar
values, how do I specify the dates in the first column as the source of dates displayed on the x-axis of a related chart (in another worksheet in the same workbook)? The plotted dollar data shows correctly but the dates on the x-axis start at 1/1/00 rather than the dates in the data worksheet. |
#2
|
|||
|
|||
specify date source for x-axis (adjacent to data column in Excel)
Make sure that there are no blank cells in the column of dates, and that the
dates not only look like dates to a human observer, but are interpreted as numerical dates by Excel. (Excel uses 1, 2, 3, etc. along the X axis if the category labels or values are non-numerical. In date terms, Excel starts with day 1 at 1-Jan-1900, or 1/1/00.) - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services - Tutorials and Custom Solutions - http://PeltierTech.com/ 2006 Excel User Conference, 19-21 April, Atlantic City, NJ http://peltiertech.com/Excel/ExcelUserConf06.html _______ "retired general" retired wrote in message ... MS Excel 2002: From a column of dates and an adjacent column of dollar values, how do I specify the dates in the first column as the source of dates displayed on the x-axis of a related chart (in another worksheet in the same workbook)? The plotted dollar data shows correctly but the dates on the x-axis start at 1/1/00 rather than the dates in the data worksheet. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Return SEARCHED Column Number of Numeric Label and Value | Sam via OfficeKB.com | Worksheet Functions | 23 | January 30th, 2006 06:16 PM |
creating a bar graph | Johnfli | General Discussion | 0 | October 26th, 2005 08:16 PM |
Help PLEASE! Not sure what answer is: Match? Index? Other? | baz | Worksheet Functions | 7 | September 3rd, 2005 03:47 PM |
QDE (Quick Date Entry) | Norman Harker | General Discussion | 3 | September 3rd, 2004 08:00 AM |
Aggregating Date Data into Weeks and Quarters | Roger | Running & Setting Up Queries | 3 | July 11th, 2004 05:56 PM |