Hi Doug, super helpful, thanks! Just a technical question: @4:14 you’ve got relative market share along the x-axis. Then at 9:30 when you are assigning axis labels, you put relative market share as the y-axis label. Is that right?
Is there a way to match the formatting colour of the sphere to the cell where we have the name, my spheres are vey close together and difficult to distinguish. if i could auto colour them to match my product name it may make the cell more easy but I'm concerned I'll mix it up if i do it by hand. can it be done automatically
Hi kai yutaka, thanks for the comment! For Revenue, depending on your data, you'll have to pull that from either public source of the companies filings (SEC 10K) in the US or for equivalent government documents for non US companies.
thanks ! i have a question, what to do if the product circle falls in the middle of the graphic? means that assumely the middle point of market share is 1.5 and the market growth is 10... if my product has the same amount, what shall i do? thankyou
one ways is to get historical numbers from govt statistics and take a % from a organization historical number or jus find data from some consulting companies
Hi everyone, I have some problems with this matrix, object at the intersection of the line. May be prefer assign this object to one sector? Who can help me?
you'll have to find it from consulting org sources or based on past data do something like a regression analysis. See some forecast video for ideas here ruclips.net/user/DougHExcelsearch?query=forecast
@@DougHExcel thanks for the response. I saw a video where the market share was used to determine the growth in the market. The current year over previous year -1 *100.
try to find it from consulting org sources or based on past data do something like a regression analysis. See some forecast video for ideas here ruclips.net/user/DougHExcelsearch?query=forecast
LOL, until recently I hadn't realized that Mario updated his favorite way to tackle ED and it's a relief! Although what he previously suggested was pretty good, it was a real pain to follow... I just go'ogled the latest in Volpstein’s Thunderous Erections, it's so much easier and potent now!
Pfffffff... so adding the labels to each bubble is manual? Seriously? That's no problem when you have only 4 bubbles. I came to this video for a way to add labels to a chart with over 90 values. I really appreciate your tips, but I can't believe MS doesn't have a way to add labels directly to a bubble chart. Un-be-lie-va-ble
in Excel 2013, MSFT finally let you do it. Right click Add Data Labels and find the option to choose Values from Cells. Then select your descriptions from a range that is associated with the series.
That would be awesome... I'm using Excel 2016, I just don't find that option. Let me see if I understand, I click on "Add Data Labels", and it gives me what is in the Y axis as label. But then I don't find where can I tell Excel where to get the labels from
You won't believe this. This. is. not. available. in. Excel 2016. Damn you Microsoft. In this article: peltiertech.com/apply-custom-data-labels-to-charted-points/ they explain what you said, but if I go to my Excel I see: * Series Name * X Value * Y Value * Show Leader Lines * Legend Key The "Value From Cells" is not an option in Excel 2016
OK, it is now. I swear the option wasn't avilable, in fact I was copying the screen to send a report to the tech-support guys, but since I had deleted the chart, I recreated it with the total confidence it wasn't going to work, and then it appeared. Maybe sometimes ventilating in the Internet makes miracles???? Thank you, thank you very much
![Noob To Max With DRAGON REWORK In Blox Fruits [FULL MOVIE]](http://i.ytimg.com/vi/LnBMOinoOvA/mqdefault.jpg)
That is massively helpful. I started using fancy bcg matrix, but what you are doing is way better.
Glad it helped!
Wow this massively helpful, i have gotten more knowledge with your explanation..
Thanks james rosita, glad it helped!
Thanks, great memory refresher for my school project :)
Hi Doug, super helpful, thanks! Just a technical question: @4:14 you’ve got relative market share along the x-axis. Then at 9:30 when you are assigning axis labels, you put relative market share as the y-axis label. Is that right?
Good Job Doug!
Thanks!
Thanks so much for taking the time!
Hi Brittany Beaudoin, glad you liked it, thanks for commenting!
Thanks!
Very useful!!!!!!! Thank you so much! You save me on Marketing task!
Glad it was helpful!
Yes yes , it indeed helped me real big time, thank you. cheers
Glad it helped!
Hi doug, you explained so well. I have done it...yahooo
Glad it helped!
Thanks for sharing! Very useful for my class!
Glad you liked!
This helps me much. Thank you so very much
You’re very welcome!
@@DougHExcel you kindly have helped many people concerning this. Thank you from Jakarta. 🙏🏽
Why did you reverse the values? Please clarify, thanks.
Thanks Doug....extremely helpful
thanks it's very useful for me.
How do you calculate relative market share and market share of largest competitor?
Thx Doug ! Clear and useful
Thank you! Massive help with my assignment
Doug, thank you very much, your tutorial helps me a lot!
Thanks Eduardo Folly, glad it helped!
very helpful, many thanks!
Glad it was helpful!
Great explication , Thank you ser
You are welcome
Thanks Doug..very helpful!!!
This is brilliant, thanks
This is so helpful. Thank you so much!
Hi Amirah Nirwan...you're welcome, glad you liked!
Thank you so much, this as really helpful
I don't know if you can do something like this for ADL MATRIX and SHELL/DPM MATRIX
Thank you
Hi Abiola Bose, Great suggestion...thanks for the comment!
thx for the video, but how can we calculate the market share of the largest competitor?
Find the company total sales(revenue) and divided by the industry's total sales. Usually organizations have this data somewhere in research reports.
Thank you very much for this great effort
Many thanks.. very useful :)
You made my day.... Great help.. Thanks
You’re welcome!
thank you its a great help...but how to find revenue...is it from the industrial profitability >?
very helpful, thanks. pls post more about EXCEL graphs :)
Good stuff!
Is there a way to match the formatting colour of the sphere to the cell where we have the name, my spheres are vey close together and difficult to distinguish. if i could auto colour them to match my product name it may make the cell more easy but I'm concerned I'll mix it up if i do it by hand. can it be done automatically
Yes but prolly with VBA
thanks for this
Welcome!
great help!!
Thanks Maurice Baggen, glad it helped!
this saved me! thx
Very usefull video ! Is there any way to automatize the label from each product ? Cause im working on 50 products in the same time so ...
Thx for tips, i tryed with VBA but didn't work, I probably failed. Anyway thx for help
I have exactly the same problem. Unbelievable MS doesn't have a way to change the labels automatically in a series formed by (label, x, y, size)
Hi Dimitri Paris, thanks for the comment!
Thank you so much!
Thanks for the video.. It's great!!
Big Thankss!
Hi Thanks Doug H.
How do you calculate the market growth?
***** Thanks. It really helps me.
Amazing amazing. thumbs up!
Hi Saima iqbal, glad you liked it, thanks for commenting!
do you have videos for creating Grand strategy, IE matrix as well?
Nope, but maybe in the future...
Thanks a lot!! This what a great help for my marketing courses!
Hi Qat M, glad you liked it, thanks for commenting!
@@DougHExcel very good video 👍🏻thanks a lot
thank you so much. It helps me! :)
Hi Roziana Rifa'e, you're welcome!
Thank you, i have a question, how do you calculated the Revenue ?
Hi kai yutaka, thanks for the comment! For Revenue, depending on your data, you'll have to pull that from either public source of the companies filings (SEC 10K) in the US or for equivalent government documents for non US companies.
what is the equation to get the Relative Market Share?
thanks ! i have a question, what to do if the product circle falls in the middle of the graphic? means that assumely the middle point of market share is 1.5 and the market growth is 10... if my product has the same amount, what shall i do? thankyou
Hi Cynthia Tirtani, thanks for the comment!
Thank you for your sharing
but how to calculate the largest competitor market share?
Hi MC James LI, thanks for the comment! Hi MC James LI, you're welcome!
it helped me but you didnt mentioned how to write low high in the corners???
those are text boxes that are added separately
From where did you find the market growth
one ways is to get historical numbers from govt statistics and take a % from a organization historical number or jus find data from some consulting companies
Hi everyone, I have some problems with this matrix, object at the intersection of the line. May be prefer assign this object to one sector? Who can help me?
How to calculate market growth?
Thanks Doug
How is the market growth calculated??
have to get the data of market share from period to period either the company or industry periodical that tracks it
How do we find the market growth
you'll have to find it from consulting org sources or based on past data do something like a regression analysis. See some forecast video for ideas here ruclips.net/user/DougHExcelsearch?query=forecast
@@DougHExcel thanks for the response. I saw a video where the market share was used to determine the growth in the market. The current year over previous year -1 *100.
thank you
thanks!
Welcome!
Thanks
Welcome!
how to get a mrket growth?
try to find it from consulting org sources or based on past data do something like a regression analysis. See some forecast video for ideas here ruclips.net/user/DougHExcelsearch?query=forecast
How is it possible that your market share is larger than the largest market share of competitors...
THANK YOOOUUUUU omg
You're Welcome!
Good Enough
Hi Shailendra Kumar, thanks for the comment!
LOL, until recently I hadn't realized that Mario updated his favorite way to tackle ED and it's a relief! Although what he previously suggested was pretty good, it was a real pain to follow... I just go'ogled the latest in Volpstein’s Thunderous Erections, it's so much easier and potent now!
Ga paham
Sorry, don’t understand the comment/ question...
@@DougHExcel The meaning is Don't understand. Because english and I don't understand about economi management. That's my language "Ga paham":)🙏🏻
안동대학교 화이팅
Hi 민유, 코멘트 주셔서 감사합니다!
Pfffffff... so adding the labels to each bubble is manual? Seriously?
That's no problem when you have only 4 bubbles. I came to this video for a way to add labels to a chart with over 90 values.
I really appreciate your tips, but I can't believe MS doesn't have a way to add labels directly to a bubble chart. Un-be-lie-va-ble
in Excel 2013, MSFT finally let you do it. Right click Add Data Labels and find the option to choose Values from Cells. Then select your descriptions from a range that is associated with the series.
That would be awesome... I'm using Excel 2016, I just don't find that option.
Let me see if I understand, I click on "Add Data Labels", and it gives me what is in the Y axis as label.
But then I don't find where can I tell Excel where to get the labels from
You won't believe this. This. is. not. available. in. Excel 2016. Damn you Microsoft.
In this article: peltiertech.com/apply-custom-data-labels-to-charted-points/ they explain what you said, but if I go to my Excel I see:
* Series Name
* X Value
* Y Value
* Show Leader Lines
* Legend Key
The "Value From Cells" is not an option in Excel 2016
OK, it is now. I swear the option wasn't avilable, in fact I was copying the screen to send a report to the tech-support guys, but since I had deleted the chart, I recreated it with the total confidence it wasn't going to work, and then it appeared.
Maybe sometimes ventilating in the Internet makes miracles????
Thank you, thank you very much
:-D
Thank you. It helped a lot.
Thanks CREATA CLASSES, glad it helped!
Thank you so much , it really helps me.
Hi radinal hakam, you're welcome!
Thank you so much
Thanks a lot!
You're welcome! 别客气!
Thank you so much !!!
You're Welcome!
Thanks
You’re welcome!
Thank you very much!
You're welcome!