Excel Pivot Chart with Slicers for Months to Show Values by Weekday Names

Hi Leila, Thank you for such simple and clear explanation, you really make it look like a a piece of cake. i found you more helpful after watch three other video from other channel. please keep it up.. very great full.

Excel is opened, Barbara, thanks for my solution

I always look specifically to you, Leila. Great explanations, Easy to understand, Concise! Thank you, Thank you, Thank you!

شكرا ميس ليلى

How the data (closing price in this case) autofill by day please?

Hi Ms. Gharani,

I been working for about two years on Excel tables for my job. I always use your videos as an important reference.

Recently I have notice that after create a Pivot Chart and adding a slicer, if I try the slicer more than one time, the graphic don't change until I press the selection on the slicer a second time or click on the graphic.

I search may options on the web but it seems there is no information about it.

I'm using Office 365 and desktop Excel version.

Any help is apreciated.

Thank you,

Ivan J Negron

Hi
Excellent videos.
I have and learning so much.
I have the dates but not the days. How can I add the days next to the dates in excell?

how to bring month in order in filters instead of shows it in rows

Hello Mam, What is the pattern of Tuesday compared to Thursday you mentioned... can u make me clear on this.

Thanks Leila. Very happy with this video.

Second Methud Text Fungtion

I have created my team dashboard through the slice be blessed

BE BLESSED

I can't stop watching Leila's videos! They are so interesting!

For Weekday, you can also use =text(B2,"mmmm").. Sorted!!

Hey there, thanks for the great vid, one question how can i use pivot charts with a table of data which expands every month. So the amount of data just gets larger and larger every day can pivot handle that ?
Kind Regards

Is there a way to get the slicer to multi select by default?

I guess you could my assignment in two minutes 😂😂😂 . I am so bad in excel as beginners

Thank you Leila, can you do a calendar dashboard using this slicer please ..

how do we use sumifs or countifs with slicer multiple selection, suppose I have a geo filter in pivot and when i select multiple geos in slicer and the formula I have applied should also get updated

How can you sort out data chronologically

Hi Leila! Hope you’re well! Do you have a tutorial for building a Dynamic Employee’s Annual Leave spreadsheet ? I can’t find one in your channel!

Hahaha. Just like Code Beauty. About 90% male viewers.
The internet is what it is...
Good luck. I'm more into Access.

Marry me

How can we distribute data week wise. I have a list of upcoming milestones for next 2 months which I want to show week wise in 8 weeks. Like W1 Sep, W2 Sep up to W4 Oct.

How do we use weekdays in power query?

I love all the info I learn from you. You make it easy to understand. Thanks!!!

Thanks very much, especially for the formatting of the slicer! I have one problem though: when I click on the slicer, the cursor always jumps to the pivot chart. Is there any way to stop this from happening? I don't see it in your video!

I like your Excel video. Very informative. But if i have a pivot slicer how can i retrieve information using count

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.

Is it possible to apply the slicer too on the data table? Column a to c?

hi help me plz (i have month name ,actual fee, Receive fee, Pending fee my problem is how can i make arrears received and arrear cell with actual fee receive fee and pending fee

In my case I could not add the slicer as month.. it’s showing only year option and quarter options..but no month option. Please help

thanks. great help. nice tutorial

I have excel2007 and can't activate the slicer, is there any trick? Thanks!

May I know how do I filter by 2 weeks instead of months? Example (1-14 Jan/15-31 JAN) as I am looking to track based on every 2 weeks? :)

You are amazing.. What a great way of explaining this concept 👏

Thank you so much.. ur video's not only motivate but also a way of solution.... thanks alot

Hi, I’m really struggling to format my pivot chart data labels....I can do one bar individually but don’t have the time to do that....I’m trying to show the currency value with , and no decimal places. My pivot data is formatted that way but pulling through in a horrible, unreadable format...🙏

With custom formating you can format the date directly. You do not need it convert it with the weekday function. :)

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

Hello, With the slicers of a pivot table, I can't keep the format (example wraps)
As soon as I click on another segment, there is no more wrapping and the box is unchecked ...

Muito obrigado! Parabéns pelo vídeo!

Thank you so much for imparting the knowledge

Hi Leila Gharani,

Ananth here writing from Bangalore, India. I am a big fan of you for the way you educate people in excel and other Microsoft products. I have learnt many many excel tricks from your channel.

I have a problem in excel. Could you please help me to resolve this issue.? if yes, please see my problem description below,

I have created a Slicer using Excel tables not using Pivot charts. I would like to fetch / print the information selected by user (in both slicers) into multiple cells in other tab for further processing.

Could you please help me to resolve this issue? Is it possible to do it?

Ananth GJ

Phone: +91 9902265005 / Whatsapp: 8861122333

Oro, puro oro por estos rumbos.