How to Create a Timeline Chart in Excel

Рет қаралды 55,805

Күн бұрын

Пікірлер: 47

@theedoreM 5 ай бұрын

Well done. The way you use the green arrows, hi-lighting, and more-visible cursor is really good. Your voice is pleasant and nicely modulated.

@GuruswamyAyyapan 5 ай бұрын

You teaching is Excellent.. thanks

@oldfartinthenight9201 5 ай бұрын

Outstanding! I can make very good use of this for both work and personal projects. Many thanks.

@444Yielding 5 ай бұрын

The way you worded some of your methods resonate with how I learn, in such a great way! This just gave me some new visual ideas to apply I'll my own case! 💯

@jamiereife5581 5 ай бұрын

Brilliant. Thank you!

@touchwithbabu 4 ай бұрын

Brilliant Video . Clear as crystal

@ricjrob 5 ай бұрын

Thats going to save me so much time. Thank you

@DarcyWhyte 4 ай бұрын

That's super cute, thanks. I think it could work nicely with all positive jitter values so that the lines don't cross the month labels.

@MADhatter_AIM 5 ай бұрын

wow, just what i needed Thanks

@noelsucgang 5 ай бұрын

Thanks for the tutorial.

@extraktAI 4 ай бұрын

Incredible, thanks a lot! 👏

@eacarvalho 5 ай бұрын

Oh that was creative. Thank you for sharing.

@shashankbisht2352 5 ай бұрын

thanks a lot for this timeline chart, will surely try it in my QBR connect 😍

@gowbie 4 ай бұрын

super helpful, thank you

@marwaclothfashion 5 ай бұрын

Incredible tutorial 👏

@sahralsahri7180 5 ай бұрын

Very nice. Thanks!🎉

@umangternate 4 ай бұрын

You got a new subscriber 🎉

@TheJoshtheboss 5 ай бұрын

Wow, very creative 👏

@dads_random_projects Ай бұрын

Good vid. Up speak was 🤯

@rudiklein 5 ай бұрын

Nice one! I would never have come up with that.

@GoingGreenMom 5 ай бұрын

Very interesting!

@ennykraft 4 ай бұрын

I always use a scatter plot for timelines. It needs numbers for the x axis so I format dates to only display the name of the month. With years this isn't a problem of course. That way if there are gaps in between (months or years where nothing happens) it looks more realistic. Column charts distribute all column with an equal distance. For the error bars you can use the Custom option, using the y values in your chart.

@stevereed5776 5 ай бұрын

Great tutorial. Thanks. What happens if you have multiple items in one month

@jonr6680 5 ай бұрын

Came for the Excel tips, stayed for The Voice, such a perfect example of natural ASMR ever, tonality, cadence, pace... all combined to make a lobotomy level sense of relaxation!!

@rudiklein 5 ай бұрын

I tried to see the whole video a coulle of times, but I kept relaxing to a level called sleep 😂.

@glenneric1 5 ай бұрын

Cool video. I'd like to adapt it for event clusters rather than evenly spaced months. We tend to have a bunch of things happening at once during hurricanes, where I work.

@rostamr4096 4 ай бұрын

very nice...thank you. how did you come up with the Height values....

@Bhavik_Khatri 5 ай бұрын

Thank you.

@luigibru8677 5 ай бұрын

It would be awesome if there was the option to have the months alternatively over and below the axis X

@richardaversa7128 5 ай бұрын

It can be done. Take off the current axis labels. Add a series, change plot style to line plot, remove lines and markers, add data labels referencing a months array. Make the heights alternate. Profit.

@m.sanikhan3849 5 ай бұрын

Xosss 😍😍😍😍

@peterjames8046 2 ай бұрын

can you do the time line using dates

@EnJeiBee 4 ай бұрын

How can you get the months on the x-axis to alternative so that the bottom lines down to the task aren't cutting through them?

@teoxengineer 5 ай бұрын

How can you create dynamic status bar which shows current date line?

@johnduck6274 4 ай бұрын

I gave it a go for a 24hr period rather than months in your example, no luck. Maybe this method is not suited to non-even units eg 32min, 10min..... rather than even months. Great vid .

@HumourHubOfficial 5 ай бұрын

I love you 😅 Thanks 👍

@rojeg1 5 ай бұрын

how can I adjust the timeline, i.e. weeks, quarters, etc.

@rojeg1 5 ай бұрын

I cannot find the workbook? Help!

@manguy2000 2 ай бұрын

Chart elements button does not appear for me....why?

@alextakats9789 5 ай бұрын

Hello, Can you please help me produce a timeline for a 36 hour period. For example that happens at 2200 on DAY 1 and the an event that happens at 0400 on Day 2?