For positioning the buttons, use the Selection Pane, use ctrl and click the active/inactive pair and do Align bottom and Alighn right and they will overlap - much more precise
Great videos btw. Really learned alot. Quick question, Is there any way I can lock the all these shapes in place and still be able to use the pivot slicer and button? When I set the slicer to locked and then protect the worksheet the slicer button no longer work
The Office Lab, how would you create a line chart comparing multiple locations. I.E. in this workbook example, comparing sales between Alabama and Florida etc.? Is this done at the pivot table level by adding states to filters?
Hi, when i select a different button in the slicer my chart template changes to the Excel standard. How do I keep it from changes and make it stay the way I want it to be? Thanks in andvance.
How do I get access to the sample data. I signed up in your website to access sample data but haven’t received any confirmation email with regards to this?? I checked the spam folder also and it’s still not there.
If you had three buttons, would you just add an additional section of code for each display (add 2 lines under 'visibility of tab buttons' and add 1 line of code under 'Visibility of tab contents')? My code below: Sub Display_Weekly_Roaster_Pace() With ActiveSheet 'Visibility of Tab Button .Shapes("Tab_Button_Week_Pace_Inactive").Visible = False .Shapes("Tab_Button_Week_Pace_Active").Visible = True .Shapes("Tab_Button_Month_Pace_Inactive").Visible = True .Shapes("Tab_Button_Month_Pace_Active").Visible = False .Shapes("Tab_Button_Year_Pace_Inactive").Visible = True .Shapes("Tab_Button_Year_Pace_Active").Visible = False
Sir I need your help, In my new office I have excel 2007 so I can't use slicers, please help how do I create Slicer for 2007 , my previous company CEO was so impressed with this dashboard for analytics and here I can't do anything , request your help sir
Hello The office lab, How to remove that (blank) value in pivot table and chart? I have tried both filter and label filter option, but when I refresh and remove filter in slicer again the blank pop ups. How to fix this?
Where exactly does that "blank" value show up? In the slicers? If that's the case, just right-click on the slicer and go to 'Slicer Settings'. Then a popup opens and in there you can select the "Hide items with no data".
hello The Office Lab we need the video for Ep. 7 because it is very important to know how to change the theme. I hope to download this here in youtube or send it to me by an email finally I would like to thank you for this tutorial
I guess you are copying the script from the website. Here is the reason. Look at the line ".Shapes(“Tab_Button_Sales_Units_Inactivective”).Visible = False". It should be "...Inactive". There is also an error related to booleans and visibility in the script from the website, but I'm sure you will handle it by your own ;)
The Office Lab can you show the vba if you would like more than 2 buttons? My version requires 4. I assume I just need four Boolean fields all false when the one that is clicked is true?
Mate - you are a Migician! I have watched all the episodes in a row. This is simply amazing!
Thank you, BezUmiaru 😊 That's great to hear! There is more to come
For positioning the buttons, use the Selection Pane, use ctrl and click the active/inactive pair and do Align bottom and Alighn right and they will overlap - much more precise
Simply, its perfect dashboard with very cool vba tricks. Thanks mate for sharing such informative video.
It is pretty Simple Yet a very Novel way to doing something so beautifully effective ! Kudos to you Mate !
Thank you 😊
Thanks man u helped me alot 🙏 i tried this method with 5 buttons it didn’t work, do u have any suggestions?
Thank yiu for your generousity in sharing your knowledge. ❤⚘
Thank you so much for sharing this amazing tutorial👍👍👍
Must creative RUclipsr I’v see thx bro!
Thanks for the compliment, Rodney 😊 I really appreciate it!
Awesome work, Thank you
It's my pleasure 😊 Thanks for your positive feedback.
That's great!
Thanks for inspiration;)
My pleasure!
Thanks so much for your help! please continue making these useful videos :)
Great videos btw. Really learned alot. Quick question, Is there any way I can lock the all these shapes in place and still be able to use the pivot slicer and button? When I set the slicer to locked and then protect the worksheet the slicer button no longer work
Anyone know? Because I just tried doing this myself
Super) Thank you very much!
Excellent, Magnificent.....
Thanks for your positive feedback, Sir 😊
You are awesome...👏👌
Thank you, Gopi 😊
The Office Lab, how would you create a line chart comparing multiple locations. I.E. in this workbook example, comparing sales between Alabama and Florida etc.? Is this done at the pivot table level by adding states to filters?
Hello, thanks for the video.
May I ask iif you encouter chart formal reset everytimee change filter ? By any chance you have any tips for this error?
Hello.Thank you for the video.Want your help please.when I type Visibility of tab buttons and content,it shows error,please help me
Hi, when i select a different button in the slicer my chart template changes to the Excel standard. How do I keep it from changes and make it stay the way I want it to be?
Thanks in andvance.
How do I get access to the sample data. I signed up in your website to access sample data but haven’t received any confirmation email with regards to this??
I checked the spam folder also and it’s still not there.
Is this possible to make similar interactive tabs for Google sheets?
If you had three buttons, would you just add an additional section of code for each display (add 2 lines under 'visibility of tab buttons' and add 1 line of code under 'Visibility of tab contents')?
My code below:
Sub Display_Weekly_Roaster_Pace()
With ActiveSheet
'Visibility of Tab Button
.Shapes("Tab_Button_Week_Pace_Inactive").Visible = False
.Shapes("Tab_Button_Week_Pace_Active").Visible = True
.Shapes("Tab_Button_Month_Pace_Inactive").Visible = True
.Shapes("Tab_Button_Month_Pace_Active").Visible = False
.Shapes("Tab_Button_Year_Pace_Inactive").Visible = True
.Shapes("Tab_Button_Year_Pace_Active").Visible = False
'Visibility of Tab Contents
.Shapes("Doughnut_Chart_Week_Pace").Visible = True
.Shapes("Doughnut_Chart_Month_Pace").Visible = False
.Shapes("Doughnut_Chart_Year_Pace").Visible = False
End With
End Sub
Sub Display_Monthly_Roaster_Pace()
With ActiveSheet
'Visibility of Tab Button
.Shapes("Tab_Button_Week_Pace_Inactive").Visible = True
.Shapes("Tab_Button_Week_Pace_Active").Visible = False
.Shapes("Tab_Button_Month_Pace_Inactive").Visible = False
.Shapes("Tab_Button_Month_Pace_Active").Visible = True
.Shapes("Tab_Button_Year_Pace_Inactive").Visible = True
.Shapes("Tab_Button_Year_Pace_Active").Visible = False
'Visibility of Tab Contents
.Shapes("Doughnut_Chart_Week_Pace").Visible = False
.Shapes("Doughnut_Chart_Month_Pace").Visible = True
.Shapes("Doughnut_Chart_Year_Pace").Visible = False
End With
End Sub
Sub Display_Yearly_Roaster_Pace()
With ActiveSheet
'Visibility of Tab Button
.Shapes("Tab_Button_Week_Pace_Inactive").Visible = True
.Shapes("Tab_Button_Week_Pace_Active").Visible = False
.Shapes("Tab_Button_Month_Pace_Inactive").Visible = True
.Shapes("Tab_Button_Month_Pace_Active").Visible = False
.Shapes("Tab_Button_Year_Pace_Inactive").Visible = False
.Shapes("Tab_Button_Year_Pace_Active").Visible = True
'Visibility of Tab Contents
.Shapes("Doughnut_Chart_Week_Pace").Visible = False
.Shapes("Doughnut_Chart_Month_Pace").Visible = False
.Shapes("Doughnut_Chart_Year_Pace").Visible = True
End With
End Sub
Thanks you in advance!!! These videos are awesome
at 9:10 , what if i want to have another button for another line chart? how can i put in Macro. Please help
Sir I need your help, In my new office I have excel 2007 so I can't use slicers, please help how do I create Slicer for 2007 , my previous company CEO was so impressed with this dashboard for analytics and here I can't do anything , request your help sir
Pls help me with only one slicer rest I will try and make it one my own , one slicer for one pivot
Hello The office lab,
How to remove that (blank) value in pivot table and chart? I have tried both filter and label filter option, but when I refresh and remove filter in slicer again the blank pop ups. How to fix this?
Where exactly does that "blank" value show up? In the slicers? If that's the case, just right-click on the slicer and go to 'Slicer Settings'. Then a popup opens and in there you can select the "Hide items with no data".
@@theofficelab it shows up in Pivot table and Pivot chart. In slicers I did the same what you said.
Hi. Did you ever figure this out? I’m having the same issue and want to exclude a zero value from the pivot table so it doesn’t appear on my chart.
Where did you get your icons for the titles?
From the integrated icon library in Excel. It's available in the latest Excel versions.
WOW 👏
hello The Office Lab
we need the video for Ep. 7 because it is very important to know how to change the theme. I hope to download this here in youtube or send it to me by an email
finally I would like to thank you for this tutorial
this is my email
am666dah66@gmail.com
I get this error:
"System error &h80070057 (-214702489). The parameter is incorrect"
Any suggestions to fix that? Thx
I guess you are copying the script from the website. Here is the reason. Look at the line ".Shapes(“Tab_Button_Sales_Units_Inactivective”).Visible = False". It should be "...Inactive". There is also an error related to booleans and visibility in the script from the website, but I'm sure you will handle it by your own ;)
Went to your site for the fee templates to try, signed up for the download password a few times but never received it
Amazingggggggg
I liked the video!!!
but too quick and complex!
Check out my new website excelfind.com for the Free Version of the Dashboard 🚀
⬇ FULL TUTORIAL SERIES PLAYLIST
[Ep. 1] Basic Dashboard ► ruclips.net/video/cKkXtyjleX4/видео.html
[Ep. 2] Background & Tile Design ► ruclips.net/video/NfEqCdfl23k/видео.html
[Ep. 3] Modern Slicer Design ► ruclips.net/video/CbDTFfoePZY/видео.html
[Ep. 4] Auto-Refresh Pivot Charts ► ruclips.net/video/Xdq7SE-z-Aw/видео.html
[Ep. 5] Interactive Info Button ► ruclips.net/video/RZW-vQRr0nY/видео.html
[Ep. 6] Interactive Dashboard Tabs ► ruclips.net/video/2qN5jUiJWMY/видео.html
[Ep. 7] Interactive Settings Menu ► ruclips.net/video/fCFGqj4QcJU/видео.html
The Office Lab can you show the vba if you would like more than 2 buttons? My version requires 4. I assume I just need four Boolean fields all false when the one that is clicked is true?