Display hours, minutes, seconds on a time-scale axis in Excel 2003
|
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 ... |
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 ... |
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 ... |
All times are GMT +1. The time now is 03:13 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com