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-

Download our free Excel utility Tool and improve your productivity:

See our Excel Products:

Visit to learn more:

Watch the best info-graphics and dynamic charts from below link:

Learn and free download best excel Dashboard template:

Learn Step by Step VBA:

Website:

Facebook:

Telegram:

Twitter:

Pinterest:

Send me your queries on telegram:
@PKanExcelExpert

************* Suggested Books *********

************* My Stuff ****************

[nsanch]

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.

[infosatish]

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!!

[devenderkumar]

Thnks PK excellent video..God bless you

[clfields]

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

[medkari]

I WANT TO THANK YOU MY BROTHER FOR YOUR GOOD WORKS

[elshanmehdiyev]

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

[tigerkhan]

Learn a lot from your videos keep up the good work

[SANILPADINJAREKARA]

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

[robanio]

Great work, man. You have been awesome!

[Kumarbehera]

Love you For teaching us stay blessed bro

[minutzionel]

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

[sushantjain]

Thanks

Which Excel version are you using?

[mehulpatel]

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%

[fhatuwanimakungo]

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 ?

[medkari]

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

[Kumarbehera]

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

[PrashantYadav-qpee]

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

[jahirhussainsheriff]

i have prepared the chart but some issues

[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.

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 ??