In my previous post, I showed you how to create a Gantt chart in 30 seconds with the Office Timeline+ add-in as pictured below.
You can grab the Office Timeline Add-in here if you missed it.
And now that you have your information in the Office Timeline+ add-in, the formatting fun begins.
The true beauty of the Office Timeline+ add-in, and why it gets our Speed Training Stamp of Approval, is that it fulfills one of our Golden Rules of Speed Training:
Never Do Anything Manually That PowerPoint Can Automatically Do For You
And the add-in does just that by getting PowerPoint to apply a wide range of customized formatting to your graphic with JUST A FEW CLICKS of your mouse…things that can otherwise take forever to pull off on your own.
Below are 5 (+ a bonus) of my favorite formatting tricks (I have a bunch more, obviously) for working with the Office Timeline+ add-in in PowerPoint.
Again, you COULD do these manually, but why bother when the add-in does all of the heavy lifting for you?
Table of Contents:
- Macro vs Micro Level Edits
- Office Timeline+ Trick #1: Splitting and Formatting Your Dates
- Office Timeline+ Trick #2: Changing and Moving Milestone Shapes
- Office Timeline+ Trick #3: Adding and Removing Task Lines
- Office Timeline+ Trick #4: Changing the Design of the Graphic
- Office Timeline+ Trick #5: Turning Your Graphic into a Table
- BONUS: Office Timeline+ Trick #6: Flipping Time Units
Apply Your Macro Level Edits First
Just like when working with PowerPoint tables or charts, there are two reasons you ALWAYS want to start with the macro level editing, usually in the Ribbon, for your graphic.
REASON #1: MACRO LEVEL FORMATTING IS APPLIED IN SECONDS
Because the add-in holds all of your Gantt chart or timeline information within it, just like a PowerPoint chart or table, there are tools in the Ribbon that will instantly update, format and change the appearance of your graphic faster than you could ever do it yourself.
Yes, you can manually format the objects yourself, but why bother when the add-in can do it all for you in seconds? You shouldn’t!
On top that, it’s also important to remember the next reason.
REASON #2: MACRO LEVEL EDITS OVERRIDE YOUR MANUAL EDITING
Just like a table or chart, macro level edits in the Ribbon have a tendency to wipe out your manual editing.
So if you start by manually editing elements of your Office Timeline+ graphic, you are likely to lose all of your effort if you later apply a Macro level edit from the Ribbon.
Office Timeline+ Trick #1: Splitting and Formatting Your Dates
[av_video src=’https://youtu.be/8e1045T7YR4′ format=’16-9′ width=’16’ height=’9′]
Splitting Your Dates:
After building your Office Timeline+ graphic (or converting your Excel data into an Office Timeline+ graphic), you are left with a variety of default formatting options that you might not like.
For example, by default, the dates start on the right side of your task bars (the text is to the right of each colored rectangle as pictured below) instead of on either side of your task bars.
Well instead of adding new shapes to your graphic and manually splitting your text, the Office Timeline+ add-in will do all of the heavy lifting for you.
Just follow these 3 steps:
Step #1: Click the Office Timeline+ tab in the Ribbon
Step #2: Open up the Date drop down
Step #3: Select your position (in this case I’ll choose Split) and your dates will automatically adjust as pictured below.
And don’t forget macro level editing reason #1 above.
Because your data lives within the graphic itself, you can quickly and easily apply new macro level formatting to all of the dates if you later change your mind about their positioning or formatting.
Formatting Your Dates
Once you have your dates split, you might also like to reformat them to open up more space in your graphic.
Let’s say you want to change the date formatting from ‘Sept 17’ to ‘9/17’. What normally is impossible to do automatically in PowerPoint, the add-in can do for you.
To change your date formatting, just follow these 3 steps:
Step #1: Click the Office Timeline+ tab
Step #2: Open up the Date Format dropdown for the Tasks group
Step #3: Select a date formatting style that you like (shorter, longer etc.) and voilà, your date formatting automatically adjusts.
Also note in the picture above that you have a variety of additional formatting options at the bottom that you can play around with, giving you even more control over your data formats (very cool).
Special Note: Formatting Milestones and Task Dates
Not only can you format the dates in your Tasks, but you have the same amazing macro level date formatting options for your Milestones too (see picture below) directly in your Office Timeline+ add-in.
Office Timeline+ Trick #2: Changing and Moving Milestone Shapes
[av_video src=’https://youtu.be/q_vi15ctxuc’ format=’16-9′ width=’16’ height=’9′]
Once you have an Office Timeline+ graphic in your presentation, you also have macro level editing capability over the shapes and positions in just a few clicks. I’ll cover both below and point out a few other wicked little features.
Changing All Of Your Milestone Shapes:
Let’s say that you don’t like the default triangles that your graphic starts with (pictured left) and you would prefer to have them pointing out (pictured right).
Well instead of having to insert a triangle and insert a line (which is how you make a flag like that) and then manually try to massage that flag into your graphic…
Once again, Office Timeline+ add-in does it all for you! Just follow these 3 simple steps:
Step #1: Navigate to the Office Timeline+ tab in your Ribbon
Step #2: Fine the Shape dropdown beneath the world ‘Milestone’
Step #3: Select your desired shape (I will select the flag shape here)
Doing so all automatically turns all of the Milestones into flags, which are re-positioned accordingly.
Changing A Single Milestone Shape:
In addition to changing all of your milestone shapes, you can also change a single shape using the Milestone task pane. Follow these 2 steps:
Step #1: Launch the Office Timeline+ Milestone task pane.
Again, note that there is a difference here between applying macro level edits to the graphic and applying micro level edits. You don’t want to mix these up. Here we are doing micro editing.
Step #2: Select your new milestone shape.
Within the dialog box, click the Shape dropdown, and select the specific milestone shape you want to change.
For this example, you could change the last milestone in your graphic from a flag to a 5-point star.
Selecting okay in the lower right-hand corner, your graphic automatically updates to include the new 5-point star in your graphic.
Inversing Your Milestone Layout
Using the same Milestone task pan, you can also split your milestones top and bottom along the time band.
Step #1: Launch the Milestone dialog box.
From the Office Timeline+ tab (1), select the Milestone command (2).
Step #2: Choose the alternate milestone command.
Within the dialog box, select the double arrow command labeled ‘Alternate milestones above and below the timeband’ in the upper right-hand corner (1).
Clicking the button once places check marks along your milestones, moving them below the timeband. Clicking the button again inverses that selection.
You can alternatively customize which milestone are above or below your time bang by checking and unchecking the boxes.
When you are finished, click the checkmark in the lower right-hand corner (2).
Clicking finish, the milestones are automatically moved above and below your time band. Again, the add-in does all of the heavy lifting for you!
Office Timeline+ Trick #3: Adding and Removing Task Lines
[av_video src=’https://youtu.be/4QWKLyUhenw’ format=’16-9′ width=’16’ height=’9′]
Another way to customize your graphic is to add or remove the horizontal and vertical task lines. Let’s look at this at the Macro and Micro levels.
Adding/Removing The Task Lines At The Macro Level
Let’s start by removing the horizontal task lines at the macro level; i.e. getting rid of all of them.
For this, we want to navigate to the Style gallery – this is where the Macro level editing magic happens.
To remove the macro level task lines, follow these steps:
Step #1: Open the Style Dialog Box
Select the Office Timeline+ tab in your Ribbon (1), and then select the Style command (2).
Step #2: Change the Horizontal Connectors
Within the Style dialog box, select the Tasks option on the left (3).
Then scroll down to the Connector section of the Style dialog box (4). Here I will tick the Hide circle for the horizontal connectors (you can see on the right a red line indicating what is going to change in the graphic) (5).
Click the check-mark in the lower right-hand corner (6).
With the horizontal task lines now gone, your graphic looks like this.
Office Timeline+ Trick #4: Changing the Design of the Graphic
[av_video src=’https://youtu.be/echb7AG_k0w’ format=’16-9′ width=’16’ height=’9′]
Just like a SmartArt graphic in PowerPoint, once the Office Timeline+ graphic is set, you can flip its layout to a different.
You can start with one type of graphic, change your mind, and then switch style. In particular, you can change between the Flat and Gel styles, which is what I’ll focus on here.
Style #1: The Flat Style – No special effect options applied to any of the graphic’s shapes
Style #2: The Gel Style – Drop shadows and 3D bevels applied to the graphic’s shapes
I personally prefer the Flat look as opposed to the Gel look, but it’s personal preference. Here’s how to quickly flip between the different style formats.
Step #1: Navigate to the Office Timeline+ tab in your Ribbon
Step #2: Open up the Change dropdown
Step #3: Select the style you prefer for your graphic (I’ve chosen the Flat/Gel graphic design)
Comparing the two styles, there are 3 main formatting differences between the two styles.
Difference #1: The timebar’s drop shadow
Difference #2: The bevel on the milestones
Difference #3: The bevel on the task bars
Office Timeline+ Trick #5: Turning Your Graphic into a Table
[av_video src=’https://youtu.be/3gV0Yc4FG0A’ format=’16-9′ width=’16’ height=’9′]
This really is my all-time favorite Office Timeline+ trick…turning your graphic into a table.
Why? Because my biggest concern when I first started playing around with the Office Timeline+ add-in was that if the data in my timeline was changed in PowerPoint, I’d lose the connection to the original data in Excel.
For example, after turning your Excel data into an Office Timeline+ graphic in PowerPoint, you make several changes to the data directly within Office Timeline+. Then your boss wants to see everything in a table beneath the timeline. The last thing you want to do is go back into Excel and have to update all the data manually, right?
Thankfully the Office Timeline+ add-in does this for you in 3 quick clicks.
Click #1: Select the Office Timeline+ tab in the Ribbon
Click #2: Select the Change command
Click #3: Select the Chronology Table
Doing so creates a new slide with a table on it as pictured below…
Now with a little bit of PowerPoint Speed Training, you can easily incorporate this table back into your graphic as pictured below.
BONUS Office Timeline+ Trick #6: Flipping Time Units
[av_video src=’https://youtu.be/ddoCOCs0jxc’ format=’16-9′ width=’16’ height=’9′]
Have you ever had a boss, client or colleague who wants you to change the time units of your graphic?
If you build your Gantt chart or timeline manually in PowerPoint this can become a HUGE task…but not with the Office Timeline+ add-in. The add-in can automatically flip the units for you in just a few clicks.
Click #1: Navigate to the Office Timeline+ tab in the Ribbon
Click #2: Open up the Style dialog box
Click #3: Choose the Scale option on the left
Click #4: Choose your unit of time (here I chose Quarters)
Note: You can see a preview of what you have selected in the window on the right.
Click #5: Click okay
Clicking okay, you can see that the time unit of your graphic is AUTOMATICALLY updated without you having to perform any calculations and/or manually update the chart.
Office Timeline Gantt Chart Trick Recap
So those are 6 of my favorite Office Timeline+ formatting tricks. I have a lot more, but for the sake of this blog post (16 pages long!), that’s a heck of a good start.
Again, the beauty of the Office Timeline+ add-in, is that it stores all of your information within the graphic itself, allowing you to quickly apply macro level formatting adjustments to the pieces of your graphic, without having to jump through a bunch of manual hoops to get the job done.
The graphic gets our Speed Training Stamp of Approval, as it gets PowerPoint to do a lot of the heavy lifting for us!
Next Do Anything Manually That PowerPoint Can Automatically Do For You
It’s never a good use of your time.
Thanks for reading, and enjoy!