| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Excel 2019 Chart Time Format
In previous versions of Excel, my X axis which is elapsed time, could be
custom formatted by entering the min, max etc. in the direct time format of 00:00:00 (hh:mm:ss). I am now using Excel 2010. If I want to enter, for example, the major division value of 1 hour, I can no longer enter 01:00:00. I must calculate the decimal equivalent of 1/24 and enter that number. What am I missing? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Line chart - time series - category axis date format (2007 VBA) | Charts and Charting in Excel | |||
| Appropriate number format to dispaly time in hours in XY chart | Charts and Charting in Excel | |||
| Excel 2003- Charts- date and time format on x-axis of XY chart | Charts and Charting in Excel | |||
| Converting a time format to a String format in Excel | Excel Discussion (Misc queries) | |||
| How to format cells in Excel for time in format mm:ss.00 | Excel Worksheet Functions | |||
Hybrid Mode
