In an earlier blog, I showed you how to covert a standard stacked column chart into something that looked more like a battery infographic, to create a more visually interesting slide. This time I’ll show you how you can replace columns in a chart with an image but set it up so that you don’t get image distortion which is created by images being stretched or compressed by the different values in your table.
Let’s start with the basic chart.
As with all charts….it’s done its job but that is where it ends.
You can then format the chart to contain an image going through the normal FORMAT DATA SERIES > FILL > PICTURE OR TEXTURE FILL and select an image from your computer. Unfortunately, although it “works”, the image becomes distorted – higher values stretch the image and smaller values compress it, giving you this;
You could argue it doesn’t make much difference, but people will invariably read more into the image than is necessary – “oooh….I wonder what a blunt tip means?”, “does the size of the rubber tell us anything?”
So you need to find a way of keeping the proportions.
To achieve this we need to create three separate images;
- Rubber tip
- Main body of the pencil
- Pencil tip
In case you are wondering, I used Photoshop to cut out the pencil and then split it into 3 sections. Not everyone has access to Photoshop, so you may need to use some more basic cropping tools. By using Photoshop I am able to control size and blank space around my cut-out shapes more easily.
It also means we need to split out the data. At the moment we have a single series – one value per month in our table.
This now needs to be split into three to match the number of images we have. Let’s give a value of 10 to represent the tip and 10 to represent the rubber end. So our new data table now looks like this:
Now re-create the table, but this time use a STACKED COLUMN chart. You should now get this:
As before, you now need to format each series by inserting the appropriate image into each series i.e. image of the tip in the top series, the main body of the pencil in the middle series and finally the rubber tip into the bottom series. Once complete you will get an undistorted image in your columns, with each tip and rubber end the same size.
Take away lines and axes, add some values above the pencils and you end up with what appears to be an infographic of some sort, ideal for a PowerPoint presentation: a nice clean image free of clutter and unnecessary detail which hopefully will be a bit more memorable than the default offering in Excel.
Here is another example using exactly the same principles but applied to a bar chart;
Far too often, people will add charts to their presentations without even attempting to make them vaguely interesting or memorable. At the end of the day, data is data and is not necessarily the most interesting thing on earth, but there is no need to bore people to death showing an endless procession of slides made up of bullets and standard charts.
Infographics are one way to make your slides more interesting and hopefully more memorable. You’ll see all sorts of infographics in the press and on the web, but many of these are created by graphic designers using specialist software which most of us will not have access to.
However, you can use in-built formatting options, and drawing tools within PowerPoint to create infographic-type shapes and images. In earlier blogs, I showed you how to create shiny spheres and transparent cylinders using only the tools and options you find in PowerPoint.
At the top of the page, you have a standard 100% chart and next to it is the same chart but with three added shapes and some formatting to make it look like a battery. Hopefully, people will remember the battery and what parts of the business give it a “full charge” compared to the rather dull standard Excel chart.
Working directly in PowerPoint, insert a chart into a slide.
Select 100% STACKED COLUMN chart type.
Click on OK.
Edit the data in the worksheet that opens.
You may need to SWITCH ROW/COLUMN to get the values stacked up properly, but once done you will get the standard Excel chart with whatever colours it selects for you by default.
It’s done its job. you could add some labels but it’s hardly memorable.
So let’s convert it into something more akin to an infographic.
First of all, get rid of anything you won’t need in the final “image” i.e. x-axis, grid lines etc. You can always remove or add elements depending on the final look you want to create.
Now to add the shiny effect to the chart to make it look like it might be a cylinder and has some depth to it:Click on one of the segments in the chart to select it.
If you are using Excel 2010 or earlier you will find a number of “interesting” preset gradients. Some of these are actually quite good for what we want to do.
If you are using 2013 or later then these preset options have disappeared and become a selection of standard colours which admittedly are less gaudy but you will have more work to do to get the final desired effect.
Whichever version you have, you will need to adjust the GRADIENT STOPS, adding light and shade sections to the chart segment. If you need to add GRADIENT STOPS just click on plus button next to the GRADIENTS STOPS . Move the marker to the appropriate position and then select a colour. This is entirely down to personal choice but for reference these are the settings I chose to achieve the look in this blog (use whichever colour you want to set up your marker positions);
- Stop 1: 0%, blue-gray, Accent 1, darker 50%
- Stop 2: 13%, light blue, Accent 1, lighter 40%
- Stop 3: 30%, blue-gray, Accent 1, darker 50%
- Stop 4: 78%, light blue, Accent 1, lighter 40%
- Stop 5: 82%, white, background 1, darker 5%
- Stop 6: 100%, blue-gray, Accent 1, darker 50%
Apply the same gradient settings to each segment picking a different colour each time. This is not as bad as it sounds. When you select GRADIENT for each segment the settings you applied are still there. All you will have to do is change the colours.
Once complete, you should have something like this;
All you need to do now is add some shapes top and bottom of the chart to create the battery effect.
Using the standard shapes, use the RECTANGLE: ROUNDED CORNERS and create two blocks to represent the top and bottom of the battery, and then a smaller third block to represent the positive or cathode end of the battery. Line them up and send them to the back so they don’t hide any of the chart. Apply the same gradient to each rectangle….and done.
There you have an editable chart that looks like a battery!
To edit your data, right click on the battery and select EDIT DATA.
Change your numbers (better still…get the data to update itself) and close the workbook to see your new updated chart/battery.