Creating a timeline chart in Excel 2013

My last two posts have both contained an timeline chart in them which I create in Microsoft Excel 2013. Since it is a fairly awesome trick, I have created a short 10min video showing how you can do it too!

imageWhile this in itself is pretty awesome to do, because it is Microsoft Office – you can easily copy and paste it into PowerPoint for presentations. Then by simply changing the Effect Options ► Sequence to By Category you can get a great effect where each event pops in one by one.

3

(click the above image to see a higher resolution version of it)

AttachmentSize
screengrab.gif3.25 MB
Stephanie's picture

Hi there,

thank you for this tutorial. Do you know how to edit the data series labels in Excel 2011?

thanks
steph

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

Post new comment

The content of this field is kept private and will not be shown publicly. If you have a Gravatar account associated with the e-mail address you provide, it will be used to display your avatar.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd>
  • Lines and paragraphs break automatically.
  • Syntax highlight code surrounded by the <pre class="brush: lang">...</pre> tags, where lang is one of the following language brushes: as3, applescript, bash, csharp, coldfusion, cpp, css, delphi, diff, erlang, groovy, jscript, java, javafx, perl, php, plain, powershell, python, ruby, sass, scala, sql, vb, xml.

More information about formatting options

By submitting this form, you accept the Mollom privacy policy.