ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Display hours, minutes, seconds on a time-scale axis in Excel 2003 (https://www.excelbanter.com/charts-charting-excel/182150-display-hours-minutes-seconds-time-scale-axis-excel-2003-a.html)

Saritha

Display hours, minutes, seconds on a time-scale axis in Excel 2003
 


Jon Peltier

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
...




Saritha

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
...





David Biddulph[_2_]

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