Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
retired general
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier
 
Posts: n/a
Default 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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
if data in one cell, then date in adjacent cell Jane Excel Worksheet Functions 8 December 22nd 07 04:34 AM
Need to Improve Code Copying/Pasting Between Workbooks David Excel Discussion (Misc queries) 1 January 6th 06 04:56 AM
Positioning Numeric Values Resulting from 6 Column Array Formula Sam via OfficeKB.com Excel Worksheet Functions 2 January 5th 06 03:03 AM
After concatenating data, how do I get Excel to recognise date? Anisette Excel Discussion (Misc queries) 9 December 29th 05 08:15 PM
Excel link to data in other worksheet only refreshes one column James Excel Discussion (Misc queries) 0 August 5th 05 05:03 PM


All times are GMT +1. The time now is 11:02 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"