3D Container Pivot Chart with Slicers and Timeline

#3DContainerChart #PivotChartsWithSlicers
Hello Friends,
In this video you will learn how to create a dynamic 3D Container Pivot Chart with slicers and Date Timeline. We have displayed the sales conversion by Zone on the chart. We have used multiple calculated field in the pivot to create this chart.
Click here to download the practice file-
www.pk-anexcelexpert.com/3d-c...
Download our free Excel utility Tool and improve your productivity:
www.pk-anexcelexpert.com/prod...
See our Excel Products:
www.pk-anexcelexpert.com/prod...
Visit to learn more:
Chart and Visualizations: www.pk-anexcelexpert.com/cate...
VBA Course: www.pk-anexcelexpert.com/vba/
Download useful Templates: www.pk-anexcelexpert.com/cate...
Dashboards: www.pk-anexcelexpert.com/exce...
Watch the best info-graphics and dynamic charts from below link:
• Dynamic Graphs
Learn and free download best excel Dashboard template:
• Excel Dashboards
Learn Step by Step VBA:
• VBA Tutorial
Website:
www.PK-AnExcelExpert.com
Facebook:
/ pkanexcelexpert
Telegram:
t.me/joinchat/AAAAAE2OnviiEk5...
Twitter:
/ priyendra_kumar
Pinterest:
/ pkanexcelexpert
Send me your queries on telegram:
@PKanExcelExpert
************ Suggested Books ********
VBA: amzn.to/2TMMikX
Excel Dashboard: amzn.to/2WZi2Fj
Power Query: amzn.to/2Ibd7xR
Power Pivot and Power BI: amzn.to/2DCg8BB
Exam Ref 70-778 (Power BI): amzn.to/2GnWYTN
************ My Stuff ***************
Mic : amzn.to/2TLnF88
Video Editor: screencast-o-matic.com/refer/...

[@nsanch0181]

Thank you PK for that video. Those are beautiful charts! A lot of people on this channel are going to be impressing their co-workers with stunning charts and graphics learned from you. Thank you.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@jackjimenezpereda9252]

Buen trabajo amigo. Un abrazo

[@info2satish]

Let me take a moment to tell the brilliance level you've shown to create this awesome dyno chart based on pivot table... killer trick PK!!

[@PKAnExcelExpert]

Thanks Satish for motivational words. Audience like you always encourage me to do something innovative in Excel. Please share it with your friends and colleagues.
Thanks again for your valuable support to my channel.

[@lalitbhandary8457]

You are a genius man, cheers!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@clfields0524]

Excellent video. I’m learning a lot from you.

[@medkari]

I WANT TO THANK YOU MY BROTHER FOR YOUR GOOD WORKS

[@PKAnExcelExpert]

This is really a big compliment. Thanks for your valuable support to my channel.

[@ingesistel]

Excelente ejemplo. Gracias.

[@PKAnExcelExpert]

Gracias

[@elshanmehdiyev6474]

I was just building a chart similar to this so it was very helpful. great thanks

[@Luciano_mp]

Nice job man. Thank you.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@Kumarbehera22]

Love you Bhai....... For teaching us stay blessed bro

[@PKAnExcelExpert]

Thanks Kumar for your appreciation. Please share it with your friends and colleagues.

[@rosanunes8080]

Very good! Thank you

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@SANILPADINJAREKARA]

You are a star... great job and you are a creative person.. keep it up..

[@PKAnExcelExpert]

Hi Sunil,
Thanks for your compliment. One request please share it in your friends circle on social media so that every one can make the most of it.

[@robanio100]

Great work, man. You have been awesome!

[@PKAnExcelExpert]

Thanks

[@cepydoang226]

It's incredible.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@devenderkumar1220]

Thnks PK excellent video..God bless you

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@tigerkhan6164]

Learn a lot from your videos keep up the good work

[@PKAnExcelExpert]

Glad to hear it

[@kmanoj392]

Beatiful

[@PKAnExcelExpert]

Thanks🙏

[@dharmendrayadav-bw2gp]

Awesome.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@nguyenngocthanhphong1726]

Thanks a lot

[@PKAnExcelExpert]

Thanks for watching

[@Kumar-kj3bl]

Great bro....

[@PKAnExcelExpert]

Thanks Kumar. Please share it with your friends and colleagues.

[@sedatelbas2304]

thank you

[@PKAnExcelExpert]

Thanks for your valuable comment.

[@ArunKumar-nj4gp]

This guy is genius

[@PKAnExcelExpert]

Thanks Arun for your appreciation. Please share it with your friends and colleagues.

[@jahirhussainsheriff8871]

Thanks lot ❤️

[@PKAnExcelExpert]

You're welcome 😊

[@rajivsd69]

Excellent 👌

[@PKAnExcelExpert]

Thanks

[@SNNJ1]

Very nice

[@PKAnExcelExpert]

Thanks for your appreciation

[@behnamebrahimi1625]

👍👌👌👌

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@fhatuwanimakungo24]

Hallo PK, please if may ask, i am trying to do something like this to show the number of Non Conformance per Trains set of every month , but i am Failing to understand which value and formula to use( i can see yours that you use sales /Sales Conversion ) , and wanted to show the Actual Number not in percentage . How best can i do the calculation ?

[@sushantjain8769]

Thanks
Which Excel version are you using?

[@PKAnExcelExpert]

Hi Shushant,
I am using excel 2013.

[@minutzionel]

do you have a webside were you can downloade all your projects ?

[@PKAnExcelExpert]

Please visit my website: WWW.PK-AnExcelExpert.Com

[@Kumarbehera22]

if i need chart & Data to veiw, then what is the Procedure

[@PKAnExcelExpert]

Please download this excel file from the link given vedio's description box.

[@medkari]

Hello sir Please i want this file to open with userform , can you prepare us this ??
i 'll thak you a lot
Thanks

[@PKAnExcelExpert]

Sure,I will definitely try to make such video very soon.

[@mehulpatel9555]

I have generate the Pivot table ,how to convert the value in % directly in pivot table and how use same value in Transparent area by using Calculated field Formula
Pls suggest for it
eg
Row label Sum of Value
1 23.92%
2 50.25%
3 19.28%
4 45.26%

[@PrashantYadav-qp2ee]

Hello Sir,
I am safety manager, I want to create a body injury chart.
For example Hand injury 11,head injury 5,foot injury 3.eye injury 2

[@mohammadjaved5205]

which ms office version is this

[@PKAnExcelExpert]

I am using excel 2013

[@jahirhussainsheriff8871]

i have prepared the chart but some issues

[@sunilkumar-jl7uf]

Bhai aap Maharaaj ho

[@PKAnExcelExpert]

Thanks Sunil for your valuable comments.

[@AashishVaghela]

Undoubtedly, this is a great chart / dashboard presentation. If given to a senior manager or director, they would go ecstatic over it. Your creations are simply great, Priyendra.
However, in this chart, as well as another chart in this video --> th-cam.com/video/5ZQfJXmj4sw/w-d-xo.html
I don't understand the concept of "TopCap" & "BottomCap" getting additional 5% each. Wouldn't that change the whole total of the figures. For example if QUALITY Score is say 83%, you would take 17% as the remaining Filler. that much is understandable, but adding the TopCap & BottomCap would be an additional 10% (5-5% each). So, aren't we creating the chart for a total of 110% or even more? Like in this chart, you have taken a 25% Label Filler, above the BottomCap just for labelling. While it looks good, but wouldn't it change the entire calculation? Aren't we creating a chart for 135% of the original values ? Eventhough this and the other cylindrical chart I mentioned in the URL above, look GREAT, but aren't they mathematically inaccurate ??