Correction: Excel 2010 Chart Time Format

JerryN

Guest

Posts: n/a

3rd Sep 2012

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?

« Excel 2019 Chart Time Format | Linking Excel charts in Powerpoint »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Import Excel 2010 table into Access 2010 - not listed as range	rob11marmion@gmail.com	Microsoft Access External Data	1	17th Feb 2013 11:04 PM
Convert 24/03/2010 date into 03/24/2010 date format	Nitesh	Microsoft Excel Programming	3	5th Jun 2010 10:44 AM
How to Convert 24/03/2010 as text into 03/24/2010 date format	Nitesh	Microsoft Excel Worksheet Functions	2	5th Jun 2010 10:34 AM
Form 4 Range of time from 1/20/2010 4:00 AM To 1/21/2010 10:00 AM	Peter Gonzalez	Microsoft Excel Worksheet Functions	2	26th Jan 2010 07:58 PM
Can't open workbook in excel 64 bit 2010 - but can in excel 2010 3	Darrell	Microsoft Excel Programming	5	12th Jan 2010 10:03 PM