11-26-2013, 07:24 AM #1
How do I label an Excel scatter chart x axis with time?
- Member Since
- Nov 26, 2013
I'm trying to create a scatter chart in Excel 2011, which has time along the X axis. My data are in minutes and seconds (e.g. 20:47). When I create the chart, the axis shows a very random division of the units (00:00, 02:53, 05:46, 08:38 ... 23:02). This obviously makes no sense at all (at least to a human!) and looks terrible.
I can't work out how to change it, as the options box (Format Axis / Scale) is in different units. The minimum is set to 0.0, the maximum to 0.016, the major unit is 0.0002, and the minor unit at 0.0004.
I have tried using both "time" and "custom" in the number category, with the custom being mm:ss, but neither makes any difference.
Ideally, the axis would go from 05:00 to 25:00 (mm:ss), and would be marked every 5 mins. Is this too much to ask???
BTW, I realise that I could fix this by just using seconds as my unit on the axis, but I don't think this is very meaningful to folks in the humanities (my subject area), so I'd really rather be able to work in minutes and seconds if that's possible.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By eleonb in forum OS X - Apps and GamesReplies: 1Last Post: 07-06-2010, 09:46 PM
By lmorett in forum OS X - Apps and GamesReplies: 0Last Post: 10-12-2009, 03:55 AM
By Oistrakh in forum OS X - Apps and GamesReplies: 2Last Post: 06-20-2009, 02:39 PM
By rockitdoc in forum Running Windows (or anything else) on your MacReplies: 1Last Post: 06-12-2009, 02:45 PM
By jkneps in forum OS X - Apps and GamesReplies: 0Last Post: 09-16-2008, 09:52 PM