New To Mac-Forums?

Welcome to our community! Join the discussion today by registering your FREE account. If you have any problems with the registration process, please contact us!

Get your questions answered by community gurus Advice and insight from world-class Apple enthusiasts Exclusive access to members-only contests, giveaways and deals

Join today!

Start a Discussion

Mac-Forums Brief

Subscribe to Mac-Forums Brief to receive special offers from Mac-Forums partners and sponsors

Join the conversation RSS
Apple Notebooks Apple's notebook computers including MacBook Pro, MacBook, MacBook Air, PowerBook, and iBook.

How do I label an Excel scatter chart x axis with time?

Post Reply New Thread Subscribe

Thread Tools

Member Since: Nov 26, 2013
Posts: 1
elki is on a distinguished road

elki is offline
Hi all,

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.

Thank you!
QUOTE Thanks

Post Reply New Thread Subscribe

« Macbook Pro slows down network | Non-retina Keyboard freeze? »
Thread Tools

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
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 Jump

Similar Threads
Thread Starter
Last Post
Setting Up Time Capsule - Problems Jetheat Internet, Networking, and Wireless 52 01-01-2012 07:00 AM
Multiple series in chart in MS Excel 2008 lmorett OS X - Apps and Games 0 10-12-2009 02:55 AM
Need Help Installing Time Capsule Jetheat OS X - Operating System 2 04-14-2008 11:34 PM
Time Capsule for remote backup only, not router??? m021478 Internet, Networking, and Wireless 0 03-05-2008 07:13 AM
Time wrong - Boot Camp / XP Phoenix Scanner Running Windows (or anything else) on your Mac 2 08-20-2007 10:23 PM

All times are GMT -4. The time now is 04:14 PM.

Powered by vBulletin
Copyright ©2000 - 2015, Jelsoft Enterprises Ltd.

Welcome to

Create your username to jump into the discussion!

New members like you have made this community the ultimate source for your Mac since 2003!

(4 digit year)

Already a member?