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
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
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!
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!
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
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.
Thank you so much for this video! I can now create a vertical timeline for my research for writing a book!
Thanks for your valuable feedback
A video worth the time. Great!
Thanks for your valuable feedback🙏
Thank You so much Sir, u made my Day🙏🙏🙏🙏🙏🙏
It's my pleasure
Congratulations PK, as you always surprise us.
Thanks for your valuable feedback
Merci bcp PK!
Awesome presentation sir 👏
Thanks for your valuable feedback
Outstanding use of error bars.
Thanks for your valuable feedback
Good job! Thanks!
Thanks for your appreciation.
Excelente!!!
Thanks for your valuable feedback
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
You ara amazing man
Thanks for your valuable feedback
@@PKAnExcelExpert I never seen an expert like you in excel. Keep going. Thank you for sharing such amazing videos.
Tnx man
Thanks for watching
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
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!
problem solved: the data formating in the chart needs to be correct, which wasnt due to copy&paste - now the timeline rocks!
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!
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
Hi Muthu,
Got your question. I will definitely make a video on this topic very soon.
@@PKAnExcelExpert Thank you sir.
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.