Build a Calendar Chart in Excel: Excel Charts Tutorial

Рет қаралды 19,678

Күн бұрын

In Part 1 of this series, you'll learn the basics of creating a calendar chart that will make your data come to life. It's perfect for project management, event planning, or any situation where time-based data needs a clear and engaging representation. 📊 DOWNLOAD THE WORKBOOK ► www.excelcampus.com/charts/ca...
🔗LINKS
🔎 Get free weekly Excel tips: www.excelcampus.com/newsletter/
💡 Free 60-minute Excel training session: www.excelcampus.com/blueprint
📖 Join Our Comprehensive Excel Training Program: www.excelcampus.com/elevate
Related Content
✅ Our New And Improved Gauge (Speedometer) Chart In Excel!: • Our New And Improved G...
✅ 8 Types of Progress Charts: • Progress Charts in Exc...
✅ Steps Chart: • How To Make A Steps Ch...
00:00 Introduction to Calendar Charts
01:05 When to use Calendar Charts
01:30 How to build Calendar Charts
13:05 How to make the charts interactive

Пікірлер: 33

@thecoursedoctor 2 ай бұрын

Jon you make me wish I was still teaching Microsoft products. This would be such a fun assignment for students to create a personalized calendar for a topic of their choice.🦋

@HamdanYouTuber 10 ай бұрын

I'm still trying to understand Excel, and your channel is one of the channels for learning Excel. Thank you for everything.

@ExcelCampus 10 ай бұрын

Thanks so much! I appreciate your support. 😊

@GarethWonfor 3 ай бұрын

Awesome alternative use of the chart!

@douglasevans2868 10 ай бұрын

This is top-tier content *and* delivery. You converted me to a subscriber. Well done!

@ExcelCampus 10 ай бұрын

Thanks Douglas! I really appreciate your support. 🙂

@amirbinmumtaz4390 10 ай бұрын

THANK YOU Boss

@IvanCortinas_ES 10 ай бұрын

Great job Jon. Excellent construction of these types of graphics. As you say, they are very useful for all types of tasks. Thank you.

@ExcelCampus 10 ай бұрын

Thanks Ivan! 🙏

@williamhougland-cdot2165 9 ай бұрын

nice job using features not normally used and using them to fulfil a need.... I didn't know about the weekday function

@markcreager3757 10 ай бұрын

Great information and delivery, learned quite a bit.

@ExcelCampus 10 ай бұрын

Glad to hear that @markcreager3757 😀

@Quidisi 10 ай бұрын

That's some amazing wizardry!!! Thanks!!!

@ExcelCampus 10 ай бұрын

Glad you like it @Quidisi 😀

@braveheartmurali 6 ай бұрын

Brilliant way to use the scatter plotter!!! Became a fan of you on the first look! :)

@ExcelCampus 6 ай бұрын

Thank you so much 😀

@HandelMcHandel 10 ай бұрын

That was complex but you explained it very well- well done!

@ExcelCampus 9 ай бұрын

Glad you think so @HandelMcHandel! 😀

@williamhougland-cdot2165 9 ай бұрын

rather than using chart title, I like to use a "text box", as the chart title wraps in ways that I don't like. using a text box as a chart title, I have more control over how it appears, when it wraps ect.

@kahfibonboy 10 ай бұрын

i have excel 2019, can you make a video or shorts to show the alternative of the filter function which only available on 2021 version. thanks

@ExcelCampus 10 ай бұрын

Thanks for the suggestion! We'll add it to our list for future videos.

@johncatsicas101 10 ай бұрын

Thank you Jon - you certainly know how to take rabbits out of the hat. Keep up this magic

@ExcelCampus 9 ай бұрын

Thanks for watching @johncatsicas101 😀

@IdoiaSota 6 ай бұрын

Thank you for the video, but I can’t make the weekday formula work…

@ExcelCampus 6 ай бұрын

Hi Idoia! 😀This is the formula for the Weekday formula in Cell T7: =VLOOKUP(T6,$Y$4:$Z$10,2,FALSE). Thank you for the support! 😊

@taneis1 2 ай бұрын

For some reason i can't download the document. I want know the formulas used. Can anyone help me with any of them?

@colinhuntley9729 9 ай бұрын

hi jon, your "build a chart" videos have inspired me to track, for instance, the days which i have run. also, i plan to track the days i have worked, as a volunteer at the european chapionships, whch takes place here in berlin, in 2024. reading previous comments, i gather that you do not answer to direct questions, whch i can understand! although i watched both part one and two on several occasions, i am still sure about many things concerning the data. i have searched ony our channel for a vdieo that would show me how to make / buuld a calandear chart really from scratch. if you have made such a video, and perhaps i am not the only person with this request, would it be possible for you to make one? kind regards fro berlin, germany, colin

@ExcelCampus 8 ай бұрын

Hi, Colin! We can certainly cover that in a monthly Live Q&A Session in Elevate Excel. We'd love to have you join Elevate! (see Elevate link in description)

@colinhuntley9729 8 ай бұрын

hi jon, i really appreciate your reply, all-the-more because i realise you have a huge work load and all the questions you must receive! i have checked out the "Elevate" link, and it sound very intersting indeed, but to be honest, my excel needs, as a pensioner, do not justify such an amount of money - although i am fully aware that you are making a great offer! i have plenty of times on my hands and will try and work out how you constructed the data. many thanks for all the videos you have presented us with and i wish you a great weekend, regards from colin huntley@@ExcelCampus

@kekaren010 6 ай бұрын

the formula =$T$3-WEEKDAY($T$3,$T$7)+1 under the Date label didn't work with me!! beside the DAY option in format Cells is not existed :( .....can anyone send the formula Link ??

@kennethokonnaya744 8 ай бұрын

I have issues with the task complete data on the chart. While the regular date stops at 8 on the x axis the task complete extends to 35 on x axis I have tried different methods to integrate it but it doesn’t work

@ExcelCampus 8 ай бұрын

I see 35 appears in the Day No. column (Column H). It could be that while selecting some of the ranges that this column was also selected unknowingly. Try walking through the video again step by step from the beginning and see if that fixes it. Hope that helps!