I'm glad it helped. Please let me know if there are other "plug in" work around ideas you'd like to see. I'll see if I can figure something out. I also post these videos on www.condensedmba.com if you want to see the whole suite of tutorials.
That will depend on if it's pivotal to show them as a player in the industry -- in which case round up to 1, and include them (although it would still be nearly impossible to read). In the majority of my use cases if someone is at 1% market share, they are effectively a non-player -- i.e., not someone I care to spend a ton of effort to depict visually on a graph. Another common thing that you could do, besides just not including them, is to lump a bunch of smaller players into an "other" group. Then in the legend, if you want, you can list who falls in "other"
Joseph Horling I believe in Excel, like in point, you can click all the lines and the chart while holding Ctrl, then right click and hit "group". If you can't do that in Excel, then copy and paste everything into PowerPoint and follow the same steps. Then you can copy and paste that grouped piece as an image and then you can even resize it without issues
This is an excellent workaround. Thanks!
hope you get to use it...i know the extension that does this easily used to cost a lot of money
Useful stuff, and well demonstrated. Thank you Brian :)
Glad it helped
Very useful. Saved me having to get a plug in.
I'm glad it helped. Please let me know if there are other "plug in" work around ideas you'd like to see. I'll see if I can figure something out. I also post these videos on www.condensedmba.com if you want to see the whole suite of tutorials.
Thank you for sharing. This is incredibly good.
Awesome. Glad it helped! Please let me know if there are any other things like this I could help with. And please consider subscribing!
Thank you Brian, appreciated
no problem
Fabulous. thank you.
Great! Glad it helped you!
Thanks for sharing. What if the % of market share of a company is less than 1%, do you not create a row for it?
That will depend on if it's pivotal to show them as a player in the industry -- in which case round up to 1, and include them (although it would still be nearly impossible to read). In the majority of my use cases if someone is at 1% market share, they are effectively a non-player -- i.e., not someone I care to spend a ton of effort to depict visually on a graph. Another common thing that you could do, besides just not including them, is to lump a bunch of smaller players into an "other" group. Then in the legend, if you want, you can list who falls in "other"
Thanks a lot mate! :)
No problem! Glad it helped!
Hi Brian,
When I draw the lines to separate the columns, they move when I move the chart. Any ideas on how to prevent this? Thanks,
Joseph Horling I believe in Excel, like in point, you can click all the lines and the chart while holding Ctrl, then right click and hit "group". If you can't do that in Excel, then copy and paste everything into PowerPoint and follow the same steps. Then you can copy and paste that grouped piece as an image and then you can even resize it without issues
Thanks Brian that worked. Enjoyed the video by the way
Joseph Horling awesome! Thanks, Joseph!
What if we have even number of cell, how to retain the middle one?
not sure if I follow
Wish I had the data to follow along better
Unfortunately the domain that I think had the data file for download expired. Were you abl to figure it out though?
Yes, I had to zoom in but it was fine. Thank you for responding and the video was great.