Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 4
Default Display hours, minutes, seconds on a time-scale axis in Excel 2003


  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default Display hours, minutes, seconds on a time-scale axis in Excel 2003

You can display these in the axis labels if you use the appropriate number
format. You can plot X with a resolution better than days only in an XY
chart, not in a line chart.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Saritha" wrote in message
...



  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 4
Default Display hours, minutes, seconds on a time-scale axis in Excel

What is the appropriate number format to dispaly time in hours, minutes in an
XY chart?

"Jon Peltier" wrote:

You can display these in the axis labels if you use the appropriate number
format. You can plot X with a resolution better than days only in an XY
chart, not in a line chart.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Saritha" wrote in message
...




  #4   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 8,651
Default Display hours, minutes, seconds on a time-scale axis in Excel

No need to ask the same question twice.
--
David Biddulph

"Saritha" wrote in message
...
What is the appropriate number format to dispaly time in hours, minutes in
an
XY chart?

"Jon Peltier" wrote:

You can display these in the axis labels if you use the appropriate
number
format. You can plot X with a resolution better than days only in an XY
chart, not in a line chart.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Saritha" wrote in message
...






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
Time-scale chart measured in hours & minutes John Charts and Charting in Excel 7 May 23rd 10 07:20 PM
How do I enter accumulated time as hours, minutes and seconds? Raz Excel Worksheet Functions 1 February 21st 08 02:30 AM
Formula to Change Hours:Minutes:Seconds to Seconds only Cheri Excel Discussion (Misc queries) 4 August 30th 06 12:44 AM
Converting hours:minutes:seconds to just minutes Dan Vagle Excel Worksheet Functions 3 July 17th 06 11:20 PM
Convert "Time Interval" in "hours : minutes : seconds" to seconds Ianukotnorth New Users to Excel 7 May 8th 05 08:11 PM


All times are GMT +1. The time now is 05:43 PM.

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"