Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
PeterS
 
Posts: n/a
Default Excel Charts X Axis values as dd/mm/yy hh:mm

I have a table with readings taken at irregular intervals.
I want the data points to be plotted along a continuous axis but when I try
to do this all the data appears against the date only and the time is ignored.
I have tried setting the x axis as time series but this doesn't work.
I can't change the units to anything but days.
Can anyone suggest a solution.
TIA
PeterS
  #2   Report Post  
Posted to microsoft.public.excel.charting
Kelly O'Day
 
Posts: n/a
Default Excel Charts X Axis values as dd/mm/yy hh:mm

Peters:

You are using a Line chart. Line charts do not let you plot less than 1 day
intervals.

I use XY (Scatter) plots for data with hours:minutes.

I suggest you change your chart type to XY then set your X Axis interval to
desired start - stop date-time and intervals.

Excel stores dates as number of days since January 1, 1900. So your dates
will look like 38867 or something.
Time is stored as fractions of a day, so 6 AM is 0.25.

That means that Excel date and time as I write this is 38867.4130. The good
news is that you can enter 5/29/06 9:54 AM and Excel will recognize it for
start value.

You can specify your interval by entering time units. For a 3 hour interval,
enter 03:00:00 , for 15 minute interval enter 00:15:00 , etc.

You have complete control over the X axis number format by using the custom
format option. You can use d:h AM/PM to show day & hr with AM/PM.

If you just want time, then h AM/PM or h:ss AM/PM.


I have some examples on my site processtrends.com



...Kelly




"PeterS" wrote in message
...
I have a table with readings taken at irregular intervals.
I want the data points to be plotted along a continuous axis but when I
try
to do this all the data appears against the date only and the time is
ignored.
I have tried setting the x axis as time series but this doesn't work.
I can't change the units to anything but days.
Can anyone suggest a solution.
TIA
PeterS



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
Null values in charts and how to override the goal seek functionality Sarge Charts and Charting in Excel 1 January 27th 06 04:57 AM
Excel Charts - Missing Values ediamond Charts and Charting in Excel 2 January 18th 06 08:56 PM
Excel does not display entered values correctly TSL1050 Excel Discussion (Misc queries) 2 January 17th 06 05:00 AM
Excel Charts - Time line for random points on X axis Anjalika Silva Excel Worksheet Functions 2 January 10th 06 10:22 PM
Excel Range Value issue (Excel 97 Vs Excel 2003) Keeno Excel Discussion (Misc queries) 2 June 13th 05 03:01 PM


All times are GMT +1. The time now is 09:31 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"