Horizontal Timeline Chart using Scatter chart in Excel

Подписаться 271 тыс.

Просмотров 82 тыс.

50% 1

#TimelineChart #ExcelInfographics
Hello Friends,
In this video, you will learn how to create a Horizontal timeline chart using Scatter Chart in Excel. This can be useful for your Project Management Dashboard or business presentation.
Click here to download the practice file:
www.pk-anexcelexpert.com/hori...
Download our free Excel utility Tool and improve your productivity:
www.pk-anexcelexpert.com/prod...
See our Excel Products:
www.pk-anexcelexpert.com/prod...
Visit to learn more:
Chart and Visualizations: www.pk-anexcelexpert.com/cate...
VBA Course: www.pk-anexcelexpert.com/vba/
Download useful Templates: www.pk-anexcelexpert.com/cate...
Dashboards: www.pk-anexcelexpert.com/exce...
Watch the best info-graphics and dynamic charts from below link:
• Dynamic Graphs
Learn and free download best excel Dashboard template:
• Excel Dashboards
Learn Step by Step VBA:
• VBA Tutorial
Website:
www.PK-AnExcelExpert.com
Facebook:
/ pkanexcelexpert
Telegram:
t.me/joinchat/AAAAAE2OnviiEk5...
Twitter:
/ priyendra_kumar
Pinterest:
/ pkanexcelexpert
Send me your queries on telegram:
@PKanExcelExpert
************ Suggested Books ********
VBA: amzn.to/2TMMikX
Excel Dashboard: amzn.to/2WZi2Fj
Power Query: amzn.to/2Ibd7xR
Power Pivot and Power BI: amzn.to/2DCg8BB
Exam Ref 70-778 (Power BI): amzn.to/2GnWYTN
************ My Stuff ***************
Mic : amzn.to/2TLnF88
Video Editor: screencast-o-matic.com/refer/...

Опубликовано:

4 июл 2019

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 51

@sukumar200281 2 года назад

Thank you so much...you make life easy with these videos ....

@cricketinwilton 2 года назад

This was incredibly useful and very well explained. Thank you!

@PKAnExcelExpert 2 года назад

Thanks for your valuable feedback🙏

@fernandoperes5164 5 лет назад

Very Well...It's perfect!!! Excel Expert !!! Master !!!

@PKAnExcelExpert 5 лет назад

Thanks for your valuable feedback

@TechInnovateTool 2 года назад

Good. Excellent brief

@thinkinglikechristians 3 года назад

Great info! Found this after some very complicated videos! This is easy to understand even if one only has a basic knowledge of excel! Excellent Video!

@PKAnExcelExpert 3 года назад

Thanks for your valuable feedback

@manhgrour6144 3 года назад

Nice Video clip! Sorry for chiming in, I would love your thoughts. Have you researched - Weydaniel Organized Dominator (Have a quick look on google cant remember the place now)? It is a good exclusive product for getting 7000 plus project management and business templates without the hard work. Ive heard some super things about it and my work buddy finally got great success with it.

@erdiaz39 3 года назад

AWESOME PK, THANKS!!!!!!!!!!!

@PKAnExcelExpert 3 года назад

Thanks for your valuable feedback.

@xiaoxiao5276 2 года назад

Thank you for the great video!!! Very good video!

@PKAnExcelExpert 2 года назад

Thanks for your valuable feedback

@medkari 5 лет назад

Always you'are good Thanks

@PKAnExcelExpert 5 лет назад

Thanks for your valuable feedback

@ziauddinkhan7003 2 года назад

Very useful. Thanks Sir!

@PKAnExcelExpert 2 года назад

You are welcome

@doraimkrishnappa566 3 года назад

thank You.... This help me

@PKAnExcelExpert 3 года назад

Glad to hear that

@chandrakr83 3 года назад

finally found it, thanks

@PKAnExcelExpert 3 года назад

Most welcome

@katesims8816 Год назад

Excellent!

@PKAnExcelExpert Год назад

Thanks🙏

@gurubalaful 2 года назад

Bro, Your are really nice person , your contents are very nice and very useful for Me, God bless you bro

@PKAnExcelExpert 2 года назад

Thanks for your valuable feedback

@Saatt79 5 лет назад

Awesome sir...👏👏👏👏 more interesting like Vertical chart....

@PKAnExcelExpert 5 лет назад

Thanks for your valuable feedback

@nadiapacxi2612 3 года назад

Just wonderful, I've been looking for "project management progress report example" for a while now, and I think this has helped. You ever tried - Peyictorier Imaginative Preeminence - (Have a quick look on google cant remember the place now ) ? It is a good exclusive guide for getting useful project management and business templates minus the hard work. Ive heard some interesting things about it and my m8 got great success with it.

@nicole6255 3 года назад

Great video. Is there a way to add more than 1 green color arrow?

@yyy4013 2 года назад

Impressive.. You are fast 👍🏻

@PKAnExcelExpert 2 года назад

Thanks for your valuable feedback

@lucalenzi9922 2 года назад

Thank you for sharing! I have question: I'd like to generate automatically, and not manually, the values of the "Position" column in order to avoid overlapping. How could it be that formula? _

@giabawa3968 3 года назад

You are amazing

@PKAnExcelExpert 3 года назад

Thanks for your valuable feedback

@maslahha7252 4 года назад

Greetings, Great video I have question if you may, how can i add multiple milestones for the same date? Thank you

@PKAnExcelExpert 4 года назад

Thanks for your valuable feedback. You can create that just keep one value in minus and second in plus

@maslahha7252 4 года назад

@@PKAnExcelExpert Good morning, Thank you

@AbdulWahab-he3ql 5 лет назад

Hi, it’s a good video, one suggestion- you’re going too fast, I think need to slow your speed so viewers can understand properly

@PKAnExcelExpert 5 лет назад

Thanks for your valuable feedback. I will take care in my future videos.

@srikanthg2187 4 года назад

Did anyone give suggestions, how to implement this in c# code

@avshae 3 года назад

how convenient that there are 7-8 days between each milestone. If you had different interval length between the milestones it would not produce a correctly-scaled timeline

@khaledsaleh8604 5 лет назад

dear mr pk why you chose this values 50,-50,80,-80 in position

@PKAnExcelExpert 5 лет назад

Hi Khaled, I have used it for height of the flag. You can change it according to your data label length.

@khaledsaleh8604 5 лет назад

@@PKAnExcelExpert thank you for immediate response

@khaledsaleh8604 5 лет назад

mr pk why you put two triangles like mirror

@PKAnExcelExpert 5 лет назад

Shape will display from the middle. If we will take only one shape then it will not be like a flag.

@khaledsaleh8604 5 лет назад

@@PKAnExcelExpert ok thank you good job

@shanabarnes1226 2 года назад

Thanks so much for posting this video! One big question: Is there any way to control the interval of the dates at the bottom of the scatter chart? I would like for my labels to start with 1-Jan-2022, and have the major vertical lines be on the first of every month for whole of 2022. Is this possible? Thanks again!

@shanadavis1011 2 года назад

I'm following up again because I see that you responded to another comment recently. Have you had any success in trying to set the horizontal axis labels to always show the first day of the month? Mine keep wanting to show the axis labels on the 18th of the month. Is this perhaps based on the day that the scatter chart was created?