Build a Calendar Chart in Excel: Excel Charts Tutorial
Вставка
- Опубліковано 3 лип 2024
- 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
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.🦋
I'm still trying to understand Excel, and your channel is one of the channels for learning Excel.
Thank you for everything.
Thanks so much! I appreciate your support. 😊
This is top-tier content *and* delivery. You converted me to a subscriber. Well done!
Thanks Douglas! I really appreciate your support. 🙂
Awesome alternative use of the chart!
THANK YOU Boss
Brilliant way to use the scatter plotter!!! Became a fan of you on the first look! :)
Thank you so much 😀
That was complex but you explained it very well- well done!
Glad you think so @HandelMcHandel! 😀
That's some amazing wizardry!!! Thanks!!!
Glad you like it @Quidisi 😀
Great job Jon. Excellent construction of these types of graphics. As you say, they are very useful for all types of tasks. Thank you.
Thanks Ivan! 🙏
Great information and delivery, learned quite a bit.
Glad to hear that @markcreager3757 😀
nice job using features not normally used and using them to fulfil a need.... I didn't know about the weekday function
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.
Thank you Jon - you certainly know how to take rabbits out of the hat. Keep up this magic
Thanks for watching @johncatsicas101 😀
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
Thanks for the suggestion! We'll add it to our list for future videos.
Thank you for the video, but I can’t make the weekday formula work…
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! 😊
For some reason i can't download the document. I want know the formulas used. Can anyone help me with any of them?
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 ??
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
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)
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
slightly deranged cause I cant find the add values from cell option when I want to change the label... send halp
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
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!