Logos In Charts
- 02:21
How to produce a pie chart where each slice of the pie is represented by a company logo.
Glossary
logos Logos In ChartsTranscript
In this workout, we're asked to produce a pie chart of the market capitalization of the largest technology companies and include their logos. So we've got the five logos at the top here, and we've got five companies and their market caps. The first thing I need to do is produce a pie chart. So I'll go to the insert ribbon, go to the pie chart dropdown, just grab that top left one. Great. For the chart title, I'll press equals and just click on that market cap. And I'd like to add some data labels. So click on the pie chart up to the chart, design, add chart elements, data labeled, and lots of options. They could be inside, outside end, I'd like outside end. I'm not finding it very obvious which slice is relating to which company so I could change the data labels. Let's do that for a second. Click on the data labels. Right click format data labels. And at the moment the value is selected. I'm going to try category name, see if that gives me the company names, and it does, but if it hadn't, I could have clicked on value from sales and then selected those items. So this is really nice. Now I really don't need this legend at the bottom, so I could click on that and then delete that.
But what I'd really like is for the logos to be in place of these colors. So I'm going to click on the Apple logo. I'll copy it by pressing control C, or I could right click and then copy. And then I click on the pie charts, but I make sure I just click again on the slice that I want to paste into. So click again on that light blue. And now I'll paste by pressing control V. Awesome.
Do the same with Microsoft. So copy. Then double click so the orange slicer, just selected control V to paste. And then same for alphabets and Amazon.
And lastly, video.
Fantastic. A pie chart with logos.