No video :(

Vertical Timeline Chart using Scatter chart in Excel

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

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

50% 1

#TimelineChart #ExcelInfographics
Hello Friends,
In this video, you will learn how to create a vertical timeline chart using Scatter Chart in Excel. A timeline chart is an effective way to visualize the different Milestones of a project. This is a dynamic Chart if you will add a new milestone in table, it will be reflected on the chart automatically. This can be useful for your Project Management Dashboard.
Click here to download the practice file:
www.pk-anexcel...
Download our free Excel utility Tool and improve your productivity:
www.pk-anexcel...
See our Excel Products:
www.pk-anexcel...
Visit to learn more:
Chart and Visualizations: www.pk-anexcel...
VBA Course: www.pk-anexcel...
Download useful Templates: www.pk-anexcel...
Dashboards: www.pk-anexcel...
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-AnExcel...
Facebook:
/ pkanexcelexpert
Telegram:
t.me/joinchat/...
Pinterest:
/ 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-m...
amzn.to/2PlFFFz

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

21 авг 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

@marvel9994 28 дней назад

Merci bcp PK!

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

Thank you so much for this video! I can now create a vertical timeline for my research for writing a book!

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

Thanks for your valuable feedback

@satishkumarkrishnamurthy2581 Год назад

A video worth the time. Great!

@PKAnExcelExpert Год назад

Thanks for your valuable feedback🙏

@stevenson5843 5 лет назад

Congratulations PK, as you always surprise us.

@PKAnExcelExpert 5 лет назад

Thanks for your valuable feedback

@Sam-iq2rm 2 года назад

Thank You so much Sir, u made my Day🙏🙏🙏🙏🙏🙏

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

It's my pleasure

@rickkeev4919 5 лет назад

Outstanding use of error bars.

@PKAnExcelExpert 5 лет назад

Thanks for your valuable feedback

@yulinliu850 5 лет назад

Good job! Thanks!

@PKAnExcelExpert 5 лет назад

Thanks for your appreciation.

@Saatt79 5 лет назад

Awesome presentation sir 👏

@PKAnExcelExpert 5 лет назад

Thanks for your valuable feedback

@rickkeev4919 5 лет назад

You can also automate updating the axis by this simple macro;Sub UpdteAxis() MinChartNumber = Application.WorksheetFunction.Min(Range("A2:A100")) MaxChartNumber = Application.WorksheetFunction.Max(Range("A2:A100")) For Each cht In ActiveSheet.ChartObjects cht.Chart.Axes(xlValue).MinimumScale = MinChartNumber cht.Chart.Axes(xlValue).MaximumScale = MaxChartNumber Next End SubWarning: no error handling in this macro

@mht581 5 лет назад

Tnx man

@PKAnExcelExpert 5 лет назад

Thanks for watching

@ericiriarte2880 5 лет назад

Excelente!!!

@PKAnExcelExpert 5 лет назад

Thanks for your valuable feedback

@ericiriarte2880 5 лет назад

Me es de muchísima utilidad este ejemplo dado que tengo que comparar ( Enero, Febrero, Marzo, Abril, Mayo, y junio 2018) vs Enero, Febrero, Marzo, Abril, Mayo, y junio 2019)... Voy a ver si me sale armar un avión con transparencia y que dentro del mismo se pinte el consumo del mes correspondiente... Deseame suerte jaj

@venkateshs9994 5 лет назад

You ara amazing man

@PKAnExcelExpert 5 лет назад

Thanks for your valuable feedback

@venkateshs9994 5 лет назад

@@PKAnExcelExpert I never seen an expert like you in excel. Keep going. Thank you for sharing such amazing videos.

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

Hi PK! Thank you for this!! Greatly appreciated! Question, can you change the colour of each flag and/or line according to groups? For instance: green for basic life events, blue for eductional achievements, red for traumatic events, etc.? Thank you (Shukria) in advance!

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

Hi PK, thanks alot for your video, very helpful! But when I add more lines to the chart they are not displayed in the timeline, even when I select the new data range, I geuss because the error indicators are not copied since they are not data but "only" format. Do you have a solution for easy adding data to be actually displayed in the timeline? That would be graet!

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

problem solved: the data formating in the chart needs to be correct, which wasnt due to copy&paste - now the timeline rocks!

@muthuraja6589 5 лет назад

Using count if: How many persons are born in all the given months and tell us which function can be used in excel to find out number of persons. 1. 02-Sep-1992 2. 03- Nov-1993 3. 04- oct-1994 4. 02-Sep-1992 5. 03- Nov-1993 6. 04- oct-1994

@PKAnExcelExpert 5 лет назад

Hi Muthu, Got your question. I will definitely make a video on this topic very soon.

@muthuraja6589 5 лет назад

@@PKAnExcelExpert Thank you sir.

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

Winner of a video, been searching for "how do you write weekly reports for the office?" for a while now, and I think this has helped. Have you ever come across - Peyictorier Imaginative Preeminence - (search on google ) ? It is an awesome one off guide for getting useful project management and business templates without the headache. Ive heard some super things about it and my brother in law got great results with it.