Excel Pivot Chart with Slicers for Months to Show Values by Weekday Names
HTML-код
- Опубликовано: 2 июл 2024
- Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
This type of interactive chart is great for impressive dashboards. Quickly learn how to create an Excel Pivot chart that's driven by pivot slicers.
⬇️ Download the workbook here: pages.xelplus.com/weekday-sli...
🌟 What You'll Learn:
- Excel's Weekday Function: Understand how to use the Weekday function to identify weekdays corresponding to specific dates.
- Creating Pivot Charts: Learn the process of transforming raw data into meaningful pivot charts.
- Adding Slicers for Interactivity: Discover how to incorporate slicers for a dynamic data exploration experience.
📊 In This Tutorial:
- Data Preparation: Starting with a stock price dataset, we use the Weekday function to assign weekdays to dates.
- Custom Formatting: Convert weekday numbers to names using Excel's custom formatting features.
- Pivot Table Insights: Convert your data into a pivot table and then into a pivot chart for a visual representation of weekdays vs. average closing prices.
- Slicer Integration: Enhance your pivot chart with slicers to filter data by specific months or criteria.
- Design Tips: Get insights into adjusting chart styles and slicer formats for a professional look.
- Data Expansion: See how easily you can update your charts by adding new data to your Excel table.
💡 Pro Tips:
- Use the Weekday function for more than just identifying days; use it to discover trends and patterns.
- Leverage pivot charts and slicers to make your data presentations more interactive and informative.
In this example I cover two topics:
1. How to get Weekday name from a given date in Excel
2. How to create a Pivot Chart controlled by a Slicer
In addition I show you how you can customize slicers in Excel to better match your report layout.
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#excel
Grab the file I used in the video from here 👉 pages.xelplus.com/weekday-slicer-file
Leila....2.5M subscribers? Wow! And the content is fantastic. I consider myself an expert in Excel, but I've just never had a reason to use pivot tables. This is just what the doctor ordered. Thanks
Excel-lent video and this slicer format I was searching for a while finally it came to me! Thank you so much Leila!!
Just found you - you are amazing and the examples/lessons you give are the easiest to follow and you give the best explanations - thank you
Your videos are really awesome! Excellent demos/examples that you present offers us a great learning experience.
New sub! Wow! Blown away with the content. Such quality, beauty, and knowledge all jam packed in each video! (Thank you, RUclips!)
Your tutorials are amazing! Concise and straight to the point
I always look specifically to you, Leila. Great explanations, Easy to understand, Concise! Thank you, Thank you, Thank you!
I can't stop watching Leila's videos! They are so interesting!
Finding your videos was the best thing ever!!! I've learned so much about excel and over the last two weeks that I've actually applied what I learned to some projects at work!!! Not only am I happy but my Leadership team at work is also happy!!!
That's GREAT! I'm really happy to hear that! Thanks for sharing :) You've done the difficult part which is applying what you learnt to your own work.
I liked it very much. It's just what I'm looking for. Thanks!
Another excellent video, that provides clear instructions for the end-user. Thank you.
I love her way talking 👍
Her language so easy to understand and explantion is clear 👏👏👏
Awesome, thank you so much for showing the slicer function along with pivot chart.
Leila, your videos are excellents and addictive. Thanks for sharing
Leila you never cease to amaze me!! Thank you for your easy to follow yet super informative vids!♥️
You are so welcome!
Thank you for the explanation on how customising slicer, .. very stylish as always with your tutorials, ...and a very sweet voice. thank you
You've helped me so much with charts and graphs. Thanks Leila!
You're very welcome!
Learnt so much from this tutorial. Excellent stuff!
I'm grateful for your tutorials. As an old-school guy, I have been learned a lot thanks to you.
Thanks for the kind words Erhan!
Great Video Leila - like your explanation on some of the in's and outs of how to manipulate a slicer. Keep them coming!
Glad to hear that Michael. You're very welcome.
OMG you are brilliant... Thanks I really need it as I am creating a dashboard now. Wish for your happiness and success in life!
Glad you can apply it to your dashboard :) You're very welcome Sasaraka.
Just discover your channel a few days ago, yours videos are awesome. Simple and precise explanations to get what you want to do. Thank you very much for your teaching... and for us!
My pleasure. Glad to have you here!
I am really blown away by the beauty of what you can create in excel. Keep it up !
Thanks, will do!
Love the videos Leila very easy to follow and results are great. In this example is it easy to include all week days in the pivot table and subsequent chart if there isn’t and data for the day in the table. Obviously as you use the slider the chart changes based on the data but would like to have 7 days showing all the time with blanks if nothing was on a Monday for example
You are so Awesome! Very easy to follow along...
Thank you so much!!!
thank you so much , each lecture I learn thing new in" excel "from you
That's great to hear Amr! You're very welcome.
Leila can you please share your email for us to have those lectures even if it costs no matter
Wow, I'm glad I subscribed, your channel is a gold mine, thank you!
I'm glad to hear that :)
I love all the info I learn from you. You make it easy to understand. Thanks!!!
You are so welcome, Rick!
You are superb. your examples are super easy to understand and likely to engage the viewer. Excellent job.
Thank you for the kind feedback.
You are amazing!!! Thank you for your time and effort. I really appreciate. This is very useful to me.
I'm very happy you find the content useful! Thank you for the nice comment :)
These are wonderful. I'm learning so much, and building my own file of templates. Thanks so much.
I'm glad you find these useful Stephen.
Again a perfect explanation !!
Yet another great video! Thank You!
I like how you take a simple chart and slicer, and turn it into something that looks so nice.
what is that quote? "simplicity is the ultimate sophistication" :)
It's easier to use the TEXT function than it is to use the WEEKDAY function. Just type =TEXT(A2,"DDDD"), that will populate the fully spelled out day "TUESDAY", or type =TEXT(A2,"DDD") will give you the 3 letter abbreviation of the day, ie. "Tue"... That will save you from having to navigate the WEEKDAY function. This also works with months by typing "MMM" or "MMMM".
@F yes, but the Pivot table doesn't seem to like the =A2 option.
Thank you so much.. ur video's not only motivate but also a way of solution.... thanks alot
Very good explanations, now I know better how to create a pivot chart. Thanks for this very good video Leila !
Happy to hear that Patrice!
To tell the truth , your explanation is 100% times better than my school teacher.
Thanks a lot this is really gonna help me in my exams tomorrow ☺😊
Good luck for tomorrow!
very very informative.Thank you, doing a great job in Excel.
Great! You're welcome Gopala.
Thank you so much for imparting the knowledge
Your videos provide so much to learn... I hv subscribed to so many other excel videos... but your videos provide every detail and huge information and clarity.... thank u so much for your help...
Thank you so much for subscribing! I’m glad you find the videos helpful.
Good explanation and suggestion for adding days of week to a pivot chart. I would have never thought of using the format to convert a date to the day of week. My solution was use the TEXT function.
Keep up the excellent work.
Thanks Training Research. Glad you found it useful :)
Thank you for you excel training, since I have developed Excel knowledge.from your videos
You're very welcome! I'm glad you enjoy the tutorials.
Very helpful. Great video.
Thank you very much for your tutorials !!
You're very welcome Rustam. Thanks for your support.
a beautiful video from a beautiful soul. Thanks a lot.
You're very welcome. Glad you like the video 😊
Thanks Leila. Very happy with this video.
You're welcome 😊
Excelente aporte. Quedó suscrito. Cordiales saludos desde Medellín Colombia.
awesome and so clear
Thank you.
great explanation. easy to learn
You are amazing.. What a great way of explaining this concept 👏
Thanks a lot 😊
It's very useful. Thanks, Leila
My pleasure. I'm glad the video is useful.
Oro, puro oro por estos rumbos.
Excellent video Leila
thanks. great help. nice tutorial
I am big fan your video's I am learning and learnt a lot from your video's. one word to describe Excellent
Very happy to hear that YoTech :)
You are just good in this.
You are a wonderful and Excel Google for all of us...
your videos are so helpful thanks
Very happy to hear that Chris :)
I regular learn from your videos, request you to make an end to end video on pivot tables from basics to extremely advanced (A-Z)
Very informative. Thanks
You're very welcome Gohar.
Interesting.
I can use this.
Thanks
Great video!
Muito obrigado! Parabéns pelo vídeo!
Excel is opened, Barbara, thanks for my solution
Like for Leila as always!
I'm using pivots and slicers for a long time, but some moments was interesting for me.
So, thank you!
Glad you found something useful John. Thanks for your support.
@@LeilaGharani Thank you! Please, dont stop to explore of excel magic and share with us. 😊
ma'm you have very wonderful knowledge.
Thank you for your support Sohail. I'm still learning all the time :)
Great video on dashboards
Thanks Douglas.
Thank You!
Hi Leila, your excel skills are excellent and very much effective in workforce management. This slicer is really nice. Can you please help with one click dashboard skills please.
Thanks for sharing, I luv your courses on Udemy too!
Thank you! I'm glad you enjoy the courses :)
Fantastic LG!
Great Information
Can I have more information on Slicers and Dashboard's
Very Nice Video... Thank you Leila
Welcome 😊
Great .. Thanks a lot.
Very interesting tutorial!,
Glad you like it Peter.
Stellar Leila..!
Awesome... 👍
Good video, Thanks Leila
You're very welcome.
You make it seem so easy and effortless. Thanks Do you have any lessoons with data to practice with?
Great stuff! Thanks a lot :-)
You're welcome Alex :)
Very nice tutorial...very helpfull...how to analyze data with merge colom few subheader, please guide us on that
Thanks again for another great video. How would you force the chart to show empty weekdays? Don’t want to see Sunday then Tuesday, for example.
Many Thanks!
You're very welcome.
Hi Leila, Greetings! Actually, I learned new things.
That's great :)
Waoo this video is most helpfull video ........ Thank you
You're very welcome. Glad you find it helpful.
BE BLESSED
it wouldn't be a problem if i tell someone that you invented the Excel, as its totally believable :D you know the options so well
Very nice video thank you very much I love 😍 it
I'm very happy to hear that!
Thank you so much
You're very welcome.
brilliant job thanks i am your previous subscriber and i also subscribe on this channel because your video give me many thinks . thanks
It's great to have you here.
I have created my team dashboard through the slice be blessed
Hi Leilal,
Thank you for the video. It's very informative.
Is there a way to show the data label on a chart only when one single button on a slicer is selected/clicked?
If filter is cleared on the slicer, I don't want the data level to be displayed as it will get clumsy.
your explanation is too good mam iam als fan of you
Thank you & thanks for your support.
Great!
very helpful
Glad to hear that!
I learnt so many things like how to have multiple columns in slicers, how to make charts much more presentable..
excellent
شكرا ميس ليلى
thanks