Dashboard Step by Step | How to build Interactive Excel Dashboard | Dynamic Chart in Excel

[@suneilhoggard550]

you are God Sir .you are totally different from others .Free Classes koi itna badiya se nhi batate .Bhagwan apko khush rakhe hum jaiso pr apka bahut upkar h sir.

[@Innozant]

Thanks Sunil..Really means a lot..Main kosish kar raha hu Premier course Free me provide karne ki...Umeed hai in course se aapke life me value add ho rahe honge

[@YogitaVaswani-j7m]

mostly i don't comment but for your channel cant control my typing Thanks For your educational tutorials it is so helpful

[@Innozant]

Thanks.Really means a lot to me

[@sandeepaswal8944]

सर आपसे Dashboard सीखने मै मुझे बहुत ही अच्छा लगरा है | मै daily आपके सारे विडोज़ revise करता रहता हूँ | मेरा डेली का रूटीन बन गया है जबतक आपके विडोज़ revise नहीं करता मै तब तक मैं प्रैक्टिस करता ही रहता हूँ | आप बहुत ही अच्छे शिक्षक हो आपको कोटि कोटि प्रणाम | सर मैने August To November हल्का फुल्का solve कर दिया है | but पूरा नहीं हो पारा है | सर और आप OFFSET function पर भी tutorial बनाये |

[@Innozant]

धन्यवाद संदीप जी ,मेरे वीडियो को इतना ज्यादा पसंद करने के लिए,और आप बहुत अच्छा सीख रहे है ये आनंदित करता है मुझे ,जरूरा आप चैनल पर बने रहिये आपको हमेशा वीडियो मिलते रहेंगे

[@swami14]

Sir....You are explaining each topic so understandable and patiently....Thanks for your effort and educating Excel skills.....

[@artiverma5122]

You are really too intelligent sir, muje b ye sb aa jaye to apki mhaan kripya hogi

[@Innozant]

Step by Step saare concept seekhenge aarto aur phir dashboard bnane ki koshish krenge to its reallys simple and interesting...Aayega samjha aur mujhse jyada acha design kr skate hain ap..Ye yakeen ap khud par aur thora sa mujh par 😄bhi kar sakte h

[@kamleshtiwari6222]

Sir, your teaching technic is awesome

[@cartoonstory_143]

Gajab knowledge Delivered in youtube channel Thanku sir 😊😊🎉🎉

[@Innozant]

Thanks..Keep learning

[@rahulrakshe1988]

Very nice sir.. i got job bcoz of u

[@Innozant]

God bless You.Happy learning

[@AnupKumar-oe2jb]

Thank you Sir, I learn a lot from your videos.. I will try to give your answer..

[@Innozant]

That's good,Keep learning

[@PankajKumar-tr7bg]

Amazing Explaination Sir..

[@vikasgawaria5330]

Happy mahashivratri sir

[@Innozant]

Happy Shivratri dear

[@awsomedesigning3019]

very informative

[@vishalsankhe480]

You are the best, Always! Thank you for uploading great video ❤️

[@Innozant]

Thanks Vishal Ji,Hope you learn fr this video

[@AvinashSingh-im4oc]

@@Innozant sir Mera Ek problem hai ye sb karne ke bad mai jaise hi Chart Title ko slect karta hu to mera Formula Bar Hide ho jata hai aur Mai Ume koi formula enter nahi kar pata Bta skte hai aisa kyo horaha hai

[@shahzadsiddiqui5117]

Ye video me bahut problem arha...1)Offset lagane ke baad jaise month change krrha 'spill' arha 2)chart me edit me jakr name daal raha to waha b error..kaise theek hoga sir ?

[@Indianmhbros]

Dear Sir, thank very useful class.

[@Innozant]

Thanks dear ..GM❤️

[@salilpattanayak7726]

Explained Super star🙏

[@AnkitSingh-mh7ee]

Dashboard is really interesting 😍

[@sonukumar-xp5sd]

Very useful video..thnks sir

[@sarojmanchanda2552]

Awesome👏

[@shubhamsachdeva6969]

Thank you very much sir for free education

[@Innozant]

Thanks Shubham..God Bless You

[@umerkayani79]

Zabardast Sir..thanks

[@amitapattanaik1071]

Very sweet & stylist ,thank

[@Innozant]

Thanks Salil ji

[@harishsingh2958]

Sir..i saw video mind blowing..your teaching style so so amz.👌👌👌👌👌👌👌👌. Sir i trying to require data....

[@Innozant]

Thanks dear

[@karthikreddy577]

Hi Team Innozant ur videos r too good and informative But It Difficult to understand Hindi lot of Southies also watching ur videos try to make a videos in English as well .Hope you get it

[@Innozant]

Yes the team is working on the subtitles we will definitely try to implement your ideas thanks a lot Karthik 🙂

[@faizaaamir1428]

Real teacher

[@Innozant]

Thanks Faiza for lovely comment,Hope you like the videos and have started learning step by step from there. It seems you are a new member of Innozant-Seed of Success Family.We welcome you dear to experience the taste of success. If you are a beginner learner then we recommend you to start with Basic playlist 1st video onwards step by step videos are uploaded there and practice file are there in Description common link provided. For issue /query during your practice feel free to connect us via Telegram - @innozantofficial Thanks & Regards Team Innozant

[@kishansingh4103]

Sir your video is vary vary nice super

[@Innozant]

Thanks dear

[@rajnarayan1739]

Hello sir app ki video me bahutkuch sikh ne ko mil raha he. Yes video me aap ne bar chat par productivity ko dikhaya , target ka bar chat kese banaya

[@Innozant]

Already explain Kiya hai dear video me❤️

[@zzzzz644]

at 08:03 in your video there is no (SPILL FORMULA), my months are showing till the month of drop-down list month using offset formula. It shows (SPILL FORMULA). what to do??

[@Innozant]

Check your formula again ..it's working fine

[@rajenprasad2]

your all video something new, i have learned more day by day i have one data, have some queries. can you suggest

[@Innozant]

@innozantofficial telegram id par send kren

[@ajinkyashinde1778]

Sir, SQL ke tutorilas kab se start honge ?

[@karankapoor200]

great desh board sir

[@ashishshiriskar123]

Superb sir 👍🙏

[@Innozant]

Thanks Ashish ji..gn

[@shrikantbadge3978]

Thank you so much sir

[@MrAsghar514099]

Very good

[@rewawaleashu1554]

Very nice class

[@rakhipatel110]

Thank you Sir

[@rohanrajbhar3542]

Sir vo month ke right side drop down option kaise aarha tha that arrow 🔽 plz know us

[@sunilbhoi_official]

i want to make a dynamic pivote and chart report for Sales and KPI dashborad. Please help me.

[@cartoonstory_143]

Hello sir es data me mujhe Quarty chart report presentation karna hoga to kese hoga

[@archananath6534]

Hi, I am stuck with the Offset formula. I have done it step by step as shown by you but the Month is changing only until Feb and the Productivity and Target details are not even coming up. Please assist. Loving your videos. They are very very helpful.

[@Innozant]

You are doing minor mistake Archana..Recap video and apply step by step as I explained in video..Still you are facing issue..kindly share your sheet @innozantofficial telegram id ..Will guide you for the same.

[@archananath6534]

@@Innozant Thanks for your response! I followed all the steps and was able to get the chart correctly. Everything is changing according to the Month selected. My only confusion is that the Month Productivity and Target Values are not changing properly where the Offset formula is. But the information is changing correctly on the chart. I was wondering why it was like that..

[@gajanandpawar8977]

Same problem

[@rananath7090]

Sir, offset run karne ke baad month serially show hone lagta hai, kya kiya jaye?

[@munshirasimraja5713]

Thank you so much for amazing teaching for interactive excel. sir it is possible by pivot table as well

[@Letters_and_covers]

sir, if possible create one play list for data cleaning..like using text to columns, find replace, substitue and all

[@Innozant]

text to column videos are already there in data validation playlist.

[@Letters_and_covers]

@@Innozant play list for data cleaning.. I mean the procedure,I had seen sir,text to columns I'm asking to keep them as a play list if possible..only for (data cleaning)

[@Innozant]

oh..thats good suggestion..You want a seprate playlist for data cleaning technique.Ok..dear

[@Letters_and_covers]

@@Innozant thank you sir💐

[@amitdhiman7307]

Great sir , I like your video. Pls share excel dashboard learning playlist.

[@Innozant]

Thanks Amit ..excel dashboard playlist is there please find it in channel

[@sricharanmalik9117]

Namaste sir, app ka video hamare liye bahut helpful hai.. Sir app jese bataye hum bilkul wayse custom mein jake Mmm likha lekin drop down me jo hai, formulla bar me v ohi dekh ta hai... Please help me sir

[@Innozant]

Naming range me jaise likhe hai waise hi lijiye . Case sensitive h

[@pabitramukherjee2187]

After coping offset function define name is disabled. How to enable it

[@chandandatta6446]

Good ☺

[@Innozant]

❤️🙏

[@AsifAli-fr2mw]

Very informative video sir but i want to ask that if months are horizontal in data sheet and productivity and targets are vertical how can we use this formula

[@kinghundred]

very nice sir

[@md.taifuranam7904]

I am Writing mmm in custom format but in my formula bar not showing date when selecting month from dropdown. As a result I Couldn't use offset. Please tell me how do this.

[@subbu.mba1987]

Dear sir, i could not get answer while showin an error # N/A in dash board productvity vs target error raised in productvity = offset( month 0,1) answer i could nt found please give me solution for that complication.

[@Ashish_work]

When i edit the chart "excel found a problem with one or more formula references in this worksheet error. shown

[@richaverma2097]

HI SIR, I HAVE ONE DOUBT. I AM STUCKED HERE IN THIS VIDEO WHILE LEARNING FROM UR DASHBOARDS PLAYLIST. I AM APPLYING SAME FORMULA AS IN YOURS. BUT I AM GETTING SPILL IN CELLS. MEANS... jaha formula lagaya hai OFFSET ka ,formula lgane ke baad niche numbers likhe aa rahe hai. i.e. SPILL . KINDLY ASSIST WHAT TO DO . THANKS FOR UPLOADING CLASSES IN A VERY EASY WAY.

[@sanjibmitra7951]

sir when I give height 1 then offset is work but when I give height other than 1 then the offset is not work.kindly suggest.

[@BharatiyaFirstThanHinduMuslim]

Time stamp 10:53 mein aapne month Jul select kiya h, but productivity 91 aur target 96 aa raha h....so iss chiz ne confuse kar diya mujhe. Pls thoda samjhaye.

[@Innozant]

Randbetween use kiya hai isliye valuebchabge ho ra hoga dear

[@prateekkosta463]

When I try to use Month Formula as a reference in productivity it is showing NA. I have watched the video many times but it still can't help me. please tell me what should I do.

[@RamSingh-ol5xz]

Nice

[@muhammadaamir4416]

Sir I have more than 10 years data and how can apply dynamic graph for such type of data.

[@Innozant]

Apply dynamic Line chart if you want to compare sales or revenue amount between these years.The process is same as i already upload dynamic chart videos.

[@AmitSharma-wu7jd]

My OFFSET function is showing only Jan Value nothing else. ......allready Watched Many Times. set custom format to mmm but My offset is showing only Jan in Month. and Productivity and Target shows #N/A error

[@gajanandpawar8977]

There is a problem while changing month formula in to productivity

[@mahimasharma2111]

When you use offset function in M2 cell and press enter key, it is displaying number, why? And when i tried this function as u explain in this video,it gives #value error. Plz explain

[@Innozant]

Dear Mahima,It may shows value error but it works.

[@adnanshoukat807]

sir...offset formula jb productvity mn name range dy kr apply krty hn to N/A ka error aa jata hai. plz guide me

[@Innozant]

Dear Adnan #NA Ka matlab hi yahi hota hai ki , incorrect argument used on formula.. Check kijiye ya to jise refer kar rahe hain wo dataset me nahi hai ya jo naming range me value hai use aap refer hi nahi kar re h

[@adnanshoukat807]

thank you sir. assignment is sovled

[@prabhakarpandey5133]

Hi bro, I have create 1 dashboard where i created 12 multiple graphs in it along with the slicers and Multiple pivot tables (earlier it's was Static but now it's a Dynamic), when I am going to connect the slicers via right click i.e. Report connection, it shows only 3 graphs, however it should shows us to 12 multiple graphs so that I can connect to each other. Please note, earlier when pivot table was static then easily it shows 12 graphs and I connected to each other but when i used dynamic pivot table with the help of offset formula and then this issue is creating....I hope u understood and Please help me if you can ? Please Note, I refreshed data many times , but still it shows 3 graphs only.

[@Innozant]

Kindly share your detailed query on @innozantofficial telegram id

[@deepaksuryavanshi23]

Sir Maine offset function ko copy Kiya but name manager disable aa raha hai why please 🙏

[@santoshchaudhary7087]

Hi good evening sir, Sir is dashboard me jab month wale column me offset ka formula laga rha hu to jan tk sahi jab month change kar rha hu to spill error aa rha hai kyoki height month ke according bash ja rhi hai =Offset(jan address,0,0,match(month ki drop down list address, month ki puri list,0),0) Please check sir.

[@Innozant]

Kuch Galati Kar rahe Hain Santosh Ji..phirse video dekhiye aur samjhke Jaise maine apply Kiya hai krke dekhiye dubara same data par pehle

[@santoshchaudhary7087]

@@Innozant ok sir.

[@kavita8390]

How did u fix this. I am having the same error, tried multiple times. Appreciate if you can advise how u fixed it pls Thanks in advance

[@irfanamalik1475]

Sir can we make the same for weekly basis

[@Innozant]

♥️👍

[@arban451]

Sir in mis interview they asked my why you convert range to table I said table provide dynamic range is this correct sir

[@Innozant]

Yes right,that means when we convert a single range into table there is no need to update source data as it's dynamically updated even if we freeze the data range on our formula

[@arban451]

Innozant sir I feel your videos are great please do videos on vba

[@arban451]

Innozant and please provide online course detail I want to join weather you are going to provide certificate

[@Innozant]

For More details on Live Classroom training session you may Whatspp us on 7065069985.Will send you all details.

[@abdulwaheed-hv8nl]

either I Squencelly follwing your dasbord series plz answer me about my query which i have mentioned in bellow

[@Innozant]

Kindly follow the course in sequence

[@chandrashekharbhosle65]

Hi wen i practice for productivity formula showing # NA error

[@Innozant]

Why..kindly show me your formula

[@priyankadhoke4465]

Sir, BPO center me use hone wala dashboard evam sabhi prakar ki reports ka ek complete session bnaiye. Kyonki hm Jha Kahi bhi jate hai to we experience puchte hai. So we unable to tell them anything.

[@sanjayTECH04]

index-match function se bhi ho sakta hai kya

[@Innozant]

Haan ..krke dekhiye attempt dear

[@sanjayTECH04]

@@Innozant Dear Sir, I visited your website , nice information, but not indicated how I can join your online class. Please guide

[@Innozant]

You may whatsapp us (Contact details provided in website) for complete course details

[@aniketpalav9097]

Sir, i practice this worksheet but when I change month to FEB it show Error "#Value"....

[@animals-video261]

Hello sir I'm getting stuck when I try to make a chart dynamic when I click on target line and edit the target error is coming that excel found a problem with one or more formula references in this workbook tried so many time and when I edit the productivity no error is coming only happen at the time of target editing.kindly give me solution

[@Innozant]

Copy the data and paste in new sheet then try this make chart,May be this sheet is macro enabled

[@animals-video261]

@@Innozant but sir Im trying in new sheet but the same error is coming

[@animals-video261]

Also sir due to spill function not able to do

[@indradutta4136]

I have done the same thing the way you have show in the above description however i am getting #value error. I have tried with the number format as well however result remain the same in first offset (month)formula.

[@Innozant]

Kindly watch the video again..you are doing some mistake

[@AmitSharma-wu7jd]

Same Problem........ Watched Many Times. My offset is showing only Jan in Month. and Productivity and Target shows #N/A error

[@abdulwaheed-hv8nl]

sir if you have any Q&A Whattsapp group where we can ask question and quries ...

[@Innozant]

@innozantofficial telegram id

[@ranjannayak99]

Productivity and Target are not matching with the source data...Error show kar raha hai while selecting month feb,march,apr from drop down...

[@Innozant]

Drop down me jo month le rahe hain pehle use custom me jaake text function se month banaye wo as a value show ho rha hoga .phir apply kriye formula

[@ranjannayak99]

@@Innozant kindly check the practice file shared here once...Still getting errors...

[@Indianmhbros]

Dear Sir, I have data need to required customized your valuable support is required to resolve the same. How can I contract you.

[@Innozant]

@innozantofficial telegram id

[@Indianmhbros]

@@Innozant thank Sir, pl can you share your contact number, so I can explain to you.

[@kavita8390]

Very nice videos on dashboard, much appreciated. I have a query , I am using A1 as my reference in offset and 1- row , 0- column but it does not work, why?

[@kavita8390]

Sorry, one more question sir, we can use count A for height and width but in that case how do we link it with drop down month?

[@Innozant]

You are doing right Kavita..What output shows

[@kavita8390]

Suppose, I have Jan month and using same offset+ match, output I am getting is Jan, Feb Not sure why? I don’t get any no as output but Jan, feb . Pls advise

[@kavita8390]

Sir, pls advise as I think the problem is not with the offset formula but Month format which I am not able to change to mmm as you advised earlier in this video. Even after selecting mmm , it is not showing in that format. Appreciate your advice here

[@Bengali_Medium_]

@@kavita8390 Yes! I have faced the same issue. getting output as Jan. it's not changing. Please Advise...

[@KumarNishant181286]

Offset use karne me Month waale me mera Jan feb dusre rows me bahar aa jata hai aur spill error dene lagta hai,

[@KumarNishant181286]

For Month = OFFSET($A$2,0,0,MATCH(B17,$A$2:$A$13,0),1) For productivity =OFFSET(Month,0,1) For Target =OFFSET(Month,0,2), Kaise Rectify hoga

[@Innozant]

Kaunsa excel version use kar rhe hain..formula again check kriye

[@KumarNishant181286]

@@Innozant Jha Ji hum Excel 365 use kar rahe hai aur is version me Jaise hi dropdown change karte hai Month ka, offset wale section me month me Month Jan se lekar dropdown k month tak aa jata hai, jo ki Productivity and Target waale offset pe overlap kar jata hai, aur spilling error deta hai, aap email id bhej dejiye, hum aapko apni excel sheet bhej denge

[@irfanhkhan7673]

Sir ji offset me feb month me error aa raha hai i tried index match and got value

[@Innozant]

👍❤️

[@artiverma5122]

Sir i have one confusions, when I try to links months list in this vedio my list not working properly, and could not find this file link , i am your new visitor, kindly help me and send me link of this file personally on my email 🙏

[@Innozant]

Which file Aarti..?Kindly send your query on mail [e-mail] You are Not Visotor Aarti..You are now a Member of Innozant Family..Happy Learning Dear..Have a wonderful career ahead.

[@irfanhkhan7673]

Sir, Unable to see dashboard practice files

[@Innozant]

Assignment master folder se download kren..link diya hua hai har video ke description me

[@PARDEEPKUMAR-ox4lm]

Resp sir Namastey!!!! Mai video Ko dekha ur custom Wali jagah par utak Raha Hu mujse nhi Ho Raha Please meri madat kijiye pls help by me mai is screen shot ki picture b bhej Raha hu jaha atak Raha hu Data validation Mai months dikha Raha h apki video mai Ur upper status bar mai date Mere se ye nhi Ho Raha please madat kare meri Namastey ke sath apka student

[@karthikreddy577]

While Practicing this Dash board im getting error Productivity and Target Getting error #NA I have declarer name range and did as process same as videos still getting error can you please help me to sort the issue

[@Innozant]

Kindly share your sheet,Will see where you did wrong

[@karthikreddy577]

sent thru mail please check and let me know .. Please rivert me thru mail or telegram

[@AATISH842001]

Sir dynamic dashboard sheet k liye v guide kr dijiye please. I have been commenting since last year but didn't get any reply. Please dhyan dijiye sir

[@Innozant]

Already dynamic sheet using offset cover kiya gya hai dear

[@AATISH842001]

@@Innozant ok sir Mai video dkhta hu please respond kijiyega sir doubt clear k liye 🙏💝

[@dharmendrasagar9260]

Sir ji aap video industrial excel aur VBA ke liye bhi banao VBA ke liye kam se kam 6 part banao sir mujhe VBA sheekna hai sir please please please please please please please please please please please please 🙏🙏🙏🙏🙏🙏

[@Innozant]

Haan dear layenge video...pehle Power series padhte Hain..

[@dharmendrasagar9260]

@@Innozant thank you sir mujhe aapke lectures bahut acche lagte hai

[@Innozant]

Thanks

[@excelforall7299]

On the belh of sir all are requested please share and like all the videos Subir das

[@Innozant]

Happy Learning

[@mayurrajude]

Data Wrong Pick Jaise hi mein Month Change kar raha hu..

[@riddhishah9574]

Target hai vo formula se aa hi nhi raha hai

[@Innozant]

Aisa kyu .kya issue aa rha hai aap ek baar excel sheet send kariye @innozantofficial telegram id par

[@uniquemobiletipstricks7714]

कृपया उर्दु ना बोले मुखातिब ये हमारी संस्कृति नहीं है कितने भी बड़े हो जाओ हिंदुत्व जिंदा रखो

[@Innozant]

Ye channel sirf learning channel hai dear..Keep focus on learning only and keep growing..👍❤️

[@uniquemobiletipstricks7714]

​​@@Innozant👍🙏जय माँ kali आप मेरी तरह हो सर जी वा love you

[@pandharinathjoshi6565]

🙏

[@Innozant]

Thanks

[@artiverma5122]

🙏👌

[@Innozant]

Thanks Arti..Good Night..Happy Learning..❤🙏🙏

[@artiverma5122]

Sir i have one confusions, when I try to links months list in this vedio my list not working properly, and could not find this file link , i am your new visitor, kindly help me and send me link of this file personally on my email 🙏

[@artiverma5122]

How r u sir

[@jayaprakash7198]

Can u please start to telling Hindi as well as English

[@Innozant]

Planing to add subtitles or start a seprate playlist for English audience

[@umeshchandarana8415]

Difficult hai samaj ne me .

[@Innozant]

Again watch kariye yadi aapne pehle saare concept padh liye hain to aayega samjh easily

[@NehaSharma-zn8dt]

Not Understand this Video Sir

[@Innozant]

Why Neha.?Recap video again and let me know

[@NehaSharma-zn8dt]

@@Innozant Hello Sir, (1): When I put Offset function front of Month Column… End Enter. Its showing VALUE. Also, when I click on Formula Function in Define Name (MONTH) is not Showing on Top Column. (2): I Didn’t understand why we Copy and Paste Formula in Define Name. And sir on which link need to click for obtain RAW DATA for practice for Current video. When i click its open your all classes. Sir, I really want to say the way you Explain or Present concepts in your videos is very helpful and easy to understand.

[@SajidShaikh-rn3wp]

sir....... i tried 5-6 time offset formula for productivity where we copy month (offset) formula and paste it as a refference in productivity(offset) but everytime it shows #N\A and literally i am tired by trying many times @innozant pls reply

[@bhupendrasingh9715]

Thank you sir

[@sarojdas08]

please sir just give a hint that how can i show only that month chart which one I select. suppose i will select march month the charts will show only march month

[@Innozant]

One way lookup option

[@abdulwaheed-hv8nl]

sir I getting trouble when I apply offset formula on month then it automiacally applied on other down cells productivity and target why? a big problem for me rite now ...

[@Innozant]

Why not you freeze your cell reference of offset

[@PARDEEPKUMAR-ox4lm]

Resp sir Namastey!!!! Mai video Ko dekha ur custom Wali jagah par utak Raha Hu mujse nhi Ho Raha Please meri madat kijiye pls help by me mai is screen shot ki picture b bhej Raha hu jaha atak Raha hu Data validation Mai months dikha Raha h apki video mai Ur upper status bar mai date Mere se ye nhi Ho Raha please madat kare meri Namastey ke sath apka student

[@Innozant]

Kuch Galata kar rahe hain aap dear..phirse video dekhke apply kriye sahi se