ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Correction: Excel 2010 Chart Time Format (https://www.excelbanter.com/charts-charting-excel/447015-correction-excel-2010-chart-time-format.html)

JerryN

Correction: Excel 2010 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?



All times are GMT +1. The time now is 02:10 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com