LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 3
Default Date & Time on X Axis

Hi I have a problem where i cannot get the date & time on the x axis. In
Excel 97 you used to be able to have the date in one cell and the time in the
next cell so that when a graph was created you would get a x axis with both
date and time showing on the major tick marks (ie 19/09/06 12:33), when you
try this on Excel 2003 you get a solid black line that i'm unable to read or
breakdown into sensible scale. Can anybody let me know how to solve this as
when you are looking at a weeks worth of data it is impossible to read any
type of date/time stamp.

Thans
 
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
Need help: convert seconds to date and time misty1 Excel Discussion (Misc queries) 2 November 26th 05 04:12 AM
How do I calculate if a date is in a certain time frame? Pe66les Excel Worksheet Functions 19 August 27th 05 11:07 PM
help with date and time wayne visser Excel Worksheet Functions 1 June 14th 05 04:10 PM
date and time ladimples247 New Users to Excel 2 February 16th 05 08:52 PM
Automatically enter date and time but only update once. PM New Users to Excel 3 January 21st 05 07:47 AM


All times are GMT +1. The time now is 12:42 PM.

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

About Us

"It's about Microsoft Excel"