Bubble Chart with 3 Variables in Excel

Hello Friends,
In this video you will learn how to create and read a bubble chart with 3 variables. I have used Sales (on Y Axis), Service level% (on X Axis) and Revenue (Size of bubbles)
Please download this excel file from below given link:
drive.google.c...
Learn and free download best excel Dashboard template:
• Excel Dashboards
Learn VBA with me:
• VBA Tutorial
Watch the best info-graphics and dynamic charts from below link:
• Dynamic Graphs
Follow me on Facebook:
/ pkan-excel-expert-9748...

[@littleluxetreasures1797]

Thank you so much! This was excellent!

[@PKAnExcelExpert]

Most welcome🙏

[@tej5349]

Thanks a lot , really helped me

[@PKAnExcelExpert]

Thanks

[@chibuezechukwu2879]

I love you manny!!!.......This is perfect intoto.

[@19street35]

Thank You! It was helpful

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@jugrajsingh321]

Thanks a lot. How do I add quadrants to this bubble chart?

[@stevereed5776]

Great tutorial, is there a way to get text in the X axis rather than percentages?

[@vgangamwar]

What is the difference between Sales & Revenue ??

[@giorgospitsos4550]

very educational video, only one question, i have excel 2007 i act similarly but on data labels- series name, it appears the whole A column as labelname for each bubble, not just A2 , if you could held :( , thanks

[@nobodynobody1235]

Thank you.

[@PKAnExcelExpert]

Most welcome

[@AtulSharma-kc1ey]

Thank you for the tutorial.
Just one thing - Option for using cell values for bubble labels is not available in Excel for Mac. So had to update it manually.

[@nixneato]

Now this is the perfect tutorial, thank you so much

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@cristinasayavedra5721]

this video was awesome, thank you!!

[@PKAnExcelExpert]

Most welcome🙏

[@sonyw810ii]

In Excel 2007 (Office laptop), I am unable to select LOB Data series to display when we format data labels. Any assistance??

[@alpeshraymane3861]

Amazing trick shared with us

[@PKAnExcelExpert]

Thanks for watching

[@BrilliantDesignOnline]

Nice work and instruction. Plotting earthquakes over time in Challis, Idaho Y=depth and size=Magnitude. I did not even know there was a bubble chart; using Excel 2003.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@dr.velmuruganc5466]

Thank you so much sir. This is very useful who are learning Excel

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@shaukatsamad2510]

Pls sir,teach how I ll get file option in my tab ribbon

[@frankhernandezii7610]

Thank you for the video! This saved the day!!

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@panchaljatin78]

Excellent video, very useful. I was stuck while making an imp PPT. This video saved me. Thanks PK

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@spatnik]

Perfect! Answered all the questions I had on creating the bubble charts in a particular way!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@30lll30]

Fantastic Tutorial!

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@jayurban5711]

Very helpful. Thanks for posting

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@pavithraganeshan483]

Great Tutorial... Very helpful

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@gattopazzo80]

How can you avoid auto-scaling of the bubbles?
I have some dynamic data that represent physical loads distribution, when I change the distribution defining parameters I would like the bubbles to resize to the new values; the problem is that they (also?) autoscale, apparently based on the size of the bigger bubble, so I basically see that only the smaller bubbles really resize.
I have found and tried to play around with an option "resize bubble to 100" but couldn´t really understand how it work; is that the right option?

[@patiencekiteto1349]

I would like to create 4 quadrants with varied colors on the plot area. How do I go about it

[@xiaoxiao5276]

Very helpful and good explanation! Thanks so much!

[@ranitakarmakar7896]

Thank u Sir....very helpful

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@marijadzincic2408]

Hello, is it possible to make bubbles interactive - for example to get the list of what a bubble refers to as you do when you click on a count in a pivot and it opens a new sheet with items that go into that count? Thanks a lot!

[@johnilsley]

Thank you PK! Very clear and concise. Helped me immensely.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@GURUG1]

Nice Video

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@christinawee7426]

Thank you. Saves my day. I wish to know whether I can swop the axis.

[@neenapisharody8323]

Thank you for the detailed explanation !!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@QueenCarryOn]

Thank you :)

[@tubeyoutsk]

Thank you.. i got what i wanted..

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@nguyenngocthanhphong1726]

Thank you so much for your effective tutorial

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@Azrael928]

Hey, this is a great tutorial. You are a good teacher.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@ildibaba1100]

you're a real master! thanks a lot for your tutorials

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@patriciaramos1110]

thank you! So easy to understand!

[@mraulsx]

Life saver!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@pallavisinha3049]

Data is not visible

[@annier6171]

that was really good thanks, helped me throw together my bubble chart for stakeholders. The only issue I had was a zillion data points on top of each other and the labels stacked over the top of each other when centred in the bubbles. Still really relevant for 2021 and O365 excel :)

[@ranitakarmakar7896]

Poor video quality.....