• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Excel Timeline Question

Lel

New Member
Hello,

First and foremost, I would like to put it out there that I'm as dumb as a rock when it comes to excel; I am the beginner of the beginners. So I apologize in advance for any frustrations I cause with my inability to understand excel stuff!

I would just like to know how to recreate the formatting shown on the picture I am uploading with this post. I've circled the main parts in red to show exactly what I would like to know. How does one make the color trail down like that? And is it possible to make a timeline as shown in the picture? And also would it be possible to make it adjustable?

Thank you for your time. lelhelp.png
 
Lel

Firstly, Welcome to the Chandoo.org Forums

You can use a Custom Number Format for the Inset Text
Select the Range
Ctrl+1
upload_2016-7-19_11-59-49.png
Add as many spaces between the "" as you require

For the Lines you can use the Insert, Shapes menu
upload_2016-7-19_12-2-5.png

But if you are going to get serious about project planning I would recommend that you use MS Project or one of the many other equivalents
 
Welcome Lel,

Please use excel option to increase or decrease Indent. (Home - Alignment tab then increase Indent)

upload_2016-7-19_10-2-23.png

Hello,

First and foremost, I would like to put it out there that I'm as dumb as a rock when it comes to excel; I am the beginner of the beginners. So I apologize in advance for any frustrations I cause with my inability to understand excel stuff!

I would just like to know how to recreate the formatting shown on the picture I am uploading with this post. I've circled the main parts in red to show exactly what I would like to know. How does one make the color trail down like that? And is it possible to make a timeline as shown in the picture? And also would it be possible to make it adjustable?

Thank you for your time. View attachment 32820
 
Back
Top