LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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
 
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 03:57 AM
Excel Charts - Missing Values ediamond Charts and Charting in Excel 2 January 18th 06 07:56 PM
Excel does not display entered values correctly TSL1050 Excel Discussion (Misc queries) 2 January 17th 06 04:00 AM
Excel Charts - Time line for random points on X axis Anjalika Silva Excel Worksheet Functions 2 January 10th 06 09:22 PM
Excel Range Value issue (Excel 97 Vs Excel 2003) Keeno Excel Discussion (Misc queries) 2 June 13th 05 02:01 PM


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