Any corporate sales presentation usually have a slide showing logos of all customers. Usually creating such a slide is very cumbersome because the logos come in all shapes and sizes. Someone has to spend inordinate amount of time resizing and aligning all the logos – and often, the slide still looks shabby
Here is a method which will solve your problem instantly.
Disclaimer: I have used many logos from various agencies and corporates for illustration purpose in this article. All company names, brand names, trademarks and logos are the property of their respective owners.
We have lots of logos. We want to add them to one slide and then arrange them. Does it not sound familiar? We have already covered a similar scenario in the pervious article – Arranging multiple pictures in few clicks!
I suggest you read this article first.
This is what you need to do. Put all the logos in one folder. Create a new slide. Insert – Picture – Select all logos and Insert.
Now you will see all pictured added and selected. Don’t worry about their size and shapes being different. PowerPoint knows how to manage.
Click on Picture Tools – Picture Layout and choose this particular layout called Picture Grid. Why only this layout, because it gives exactly what we want – logos nicely distributed in a grid and no text titles overlapping on the pictures. All other layouts have some problem or the other. You can try them yourself and notice the problems.
For now, trust me. Choose Picture Grid layout. Resize the overall SmartArt diagram and you have got all logos distributed nicely.
Miraculous but not very useful at this stage. Why not? Look at such a diagram I have already created… (showing only part of the SmartArt diagram here).
Most of the logos are truncated. This is a problem because showing a partial logo is simply unacceptable. Why does this happen? Because PowerPoint has square boxes and the pictures are not perfectly square. If a logo happens to be perfectly square, it will fit in well. But in other cases, PowerPoint uses a FILL option which means the available area is filled with the central portion of the picture.
This is ok if the pictures are showing nature, photos and so on. But in case of logos, the entire picture must be seen.
How do we adjust that? The solution is called FIT. This is available only in Office 2010 and above.
This is a part of the new, improved Crop feature. Crop has been there for decades but it got a major facelift in Office 2010.
I am applying a regular crop to the top left picture. See what happens…
The white part is the shape in which the picture is inserted. The gray area shows the entire extent of the picture and you can see that the central portion of the picture is FILLing the shape.
We don’t want this. So open the Crop dropdown and choose FIT option…
Now the logo fits into the available space and this is exactly want we want.
Problem solved? Not yet!
Unfortunately, this option called Fit is not available when you select multiple pictures. That is sad because now you will have to click on each picture and and keep clicking on Crop – Fit. You can simplify this a little by right clicking on Fit option, adding it to Quick Access toolbar, customize the QAT it so that it is one of the 9 options and use a shortcut Alt – Fit button number.
Now all the logos fit well. However, it is obviously cumbersome.
But what to do? If there is no choice, we have to do it.
No way. Of course there is a choice. This is a perfect example for some programming. You don’t have to do it. I have already done it. You just have to use it.
The macro shown above will work only with PowerPoint 2010 and above.
To make this happen, I wrote a macro called FitPic. You can download the file and use the macro. Unfortunately, because it is a macro, all sorts of security issues come up. Therefore, downloading and installing the macro is a rather tedious process.
But if you need this auto-fit pictures functionality many times, it is worth the effort. Otherwise, just apply fit effect one by one.
Please use the macro at your own risk. Me or my organization is not liable for any damage, file corruption or content loss or any related loss.
The code is available. You can test it before using it if you like.
Here are the steps
Click on this link to download the macro file.
My OneDrive folder will open.
The file FitSmartArtPics.zip (490KB) will automatically be selected. Just click on the Download button. Yes that is how OneDrive works
Create a new folder. For example, C:\temp.
Unzip the FitSmartArtPics.zip file and extract the FitSmartArtPics.PPTM file
Choose File – Options – Trust Settings
Choose Trusted Locations
Choose Add new location button
Now choose the folder where you have put the FitSmartArtPics.PPTM file.
Click Ok and close the Trust Center.
Close and reopen PowerPoint. Open the file FitSmartArtPics.PPTM and keep it open. I have made the file Mark as Final to prevent inadvertent changes to it. This file just needs to be open. Don’t edit it.
Technically, I could have created an Add-in as well. But I found it easier to provide the file itself because many users may not have the rights to install an add-in.
How to use the Macro
Create or open any presentation which contains SmartArt containing pictures. Although I have tested the macro, I myself would use it like this.
Create a copy of the slide on which the SmartArt is already created. So that in case something goes wrong, the copy of the slide can simply be deleted. Save the presentation.
Make sure you are in Normal view (not slide sorter view). Keep this slide open.
Now press Alt F8 – this will open the Macros dialog.
Open the Macro in dropdown and choose All open presentations. Click on the FitPic macro. Click on Run.
Now all the pictures in the SmartArt will be applied the FIT option automatically. That’s it.
Yes it is tedious. But this is a one time effort. If you need Fit option for many diagrams, this effort is absolutely worth it.
What exactly does the macro do?
This is only for developers. If you do not understand programming, just skip this section and use the macro.
The macro looks only at the current slide in the active window. It works only if the presentation is in Normal or Slide view. If the current slide does not have a SmartArt diagram, it will generate a warning and exit.
Error handling is very basic (On Error Resume Next). In rare cases when the SmartArt pic is missing or corrupted you may actually get errors. Otherwise the code is error free.
Once SmartArt is found, it goes through all nodes and all shapes in each node. If the shape is filled with Picture, it applies the Fit command otherwise ignores it.
— x —