Excel Pivot Chart with Slicers for Months to Show Values by Weekday Names
ฝัง
- เผยแพร่เมื่อ 5 ก.ค. 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
I can't stop watching Leila's videos! They are so interesting!
New sub! Wow! Blown away with the content. Such quality, beauty, and knowledge all jam packed in each video! (Thank you, TH-cam!)
I always look specifically to you, Leila. Great explanations, Easy to understand, Concise! Thank you, Thank you, Thank you!
Your videos are really awesome! Excellent demos/examples that you present offers us a great learning experience.
Your tutorials are amazing! Concise and straight to the point
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
Thank you so much.. ur video's not only motivate but also a way of solution.... thanks alot
Another excellent video, that provides clear instructions for the end-user. Thank you.
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.
Learnt so much from this tutorial. Excellent stuff!
Awesome, thank you so much for showing the slicer function along with pivot chart.
I liked it very much. It's just what I'm looking for. Thanks!
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
Leila, your videos are excellents and addictive. Thanks for sharing
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.
You've helped me so much with charts and graphs. Thanks Leila!
You're very welcome!
I love her way talking 👍
Her language so easy to understand and explantion is clear 👏👏👏
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
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.
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
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 :)
I am really blown away by the beauty of what you can create in excel. Keep it up !
Thanks, will do!
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'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!
Wow, I'm glad I subscribed, your channel is a gold mine, thank you!
I'm glad to hear that :)
Again a perfect explanation !!
You are so Awesome! Very easy to follow along...
Thank you so much!!!
You are superb. your examples are super easy to understand and likely to engage the viewer. Excellent job.
Thank you for the kind feedback.
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.
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.
very very informative.Thank you, doing a great job in Excel.
Great! You're welcome Gopala.
I love all the info I learn from you. You make it easy to understand. Thanks!!!
You are so welcome, Rick!
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 :)
Yet another great video! Thank You!
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!
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" :)
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!
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.
Thank you so much for imparting the knowledge
Thanks Leila. Very happy with this video.
You're welcome 😊
Excelente aporte. Quedó suscrito. Cordiales saludos desde Medellín Colombia.
great explanation. easy to learn
Thank you very much for your tutorials !!
You're very welcome Rustam. Thanks for your support.
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 amazing.. What a great way of explaining this concept 👏
Thanks a lot 😊
Excel is opened, Barbara, thanks for my solution
a beautiful video from a beautiful soul. Thanks a lot.
You're very welcome. Glad you like the video 😊
awesome and so clear
Thank you.
Excellent video Leila
Oro, puro oro por estos rumbos.
You are a wonderful and Excel Google for all of us...
Very informative. Thanks
You're very welcome Gohar.
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. 😊
Muito obrigado! Parabéns pelo vídeo!
It's very useful. Thanks, Leila
My pleasure. I'm glad the video is useful.
Thanks for sharing, I luv your courses on Udemy too!
Thank you! I'm glad you enjoy the courses :)
your videos are so helpful thanks
Very happy to hear that Chris :)
Very helpful. Great video.
Great video!
Interesting.
I can use this.
Thanks
ma'm you have very wonderful knowledge.
Thank you for your support Sohail. I'm still learning all the time :)
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)
You are just good in this.
Thank You!
thanks. great help. nice tutorial
Fantastic LG!
Great Information
Can I have more information on Slicers and Dashboard's
Great video on dashboards
Thanks Douglas.
Great .. Thanks a lot.
Waoo this video is most helpfull video ........ Thank you
You're very welcome. Glad you find it helpful.
Hi Leila, Greetings! Actually, I learned new things.
That's great :)
Stellar Leila..!
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 interesting tutorial!,
Glad you like it Peter.
Good video, Thanks Leila
You're very welcome.
your explanation is too good mam iam als fan of you
Thank you & thanks for your support.
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.
You make it seem so easy and effortless. Thanks Do you have any lessoons with data to practice with?
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.
BE BLESSED
Great stuff! Thanks a lot :-)
You're welcome Alex :)
Awesome... 👍
Very Nice Video... Thank you Leila
Welcome 😊
شكرا ميس ليلى
I have created my team dashboard through the slice be blessed
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.
Thank you so much
You're very welcome.
very helpful
Glad to hear that!
thanks
Hi Leila. Great lesson! I find It very useful. I've prepared annual charts with Slicers for the sum of sales on different weekdays. Now I want to compare January (or any other month) weekday sum of sales (so I am not using averages but sums) between different years. However, I would like to add one more column to the chart and that is the sum of monthly sales. How can I do that?
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.
Thanks for making so many great excel videos. These are so useful in the work. I have a question about slicer. If you have multiple slicers, is there a way to make them stay at the same place not collapse? One day I tried to add multiple slicers and adjust them the size I liked. However, when I tried to play with them, I found by select different categories, these slicers will move and not stay at the same position I organized first. Do you have an idea why? By the way, could we link the slicers to a different pivot table which we used the same data source? Could you please advice me? Thank you.
Great!
Very nice tutorial...very helpfull...how to analyze data with merge colom few subheader, please guide us on that
Firstly, many thanks to your tutorials on TH-cam and on your website. Those helped me to boot my productivity levels in using Excel.
Here is my requirement:
1. I want to create a excel like interface with rows and columns in SharePoint with borders as my team members are familiar with excel.
2. When adding a new item in list, most of the columns need to be updated from auto-populated list for each column.
3. This list of options for each column will change on weekly basis and that is captured in an excel workbook which I want to connect to this SharePoint list.
If this can be achieved, please guide me.
If this requirement can be achieved with other set of office apps in a better way, please suggest.