PMG Digital Made for Humans

Images on Excel Graphs

2 MINUTE READ | June 8, 2016

Images on Excel Graphs

Author's headshot

Val Karkauskas

Val Karkauskas has written this article. More details coming soon.

Let’s say you are working on a super important analytics project, like trying to figure out Brad Pitt’s attractiveness formula. Everyone agrees that images ‘speak’ louder than words or numbers but most still have some problems adding illustrations on excel graphs. Let’s see if we can help. Graph below shows generational appeal for Brad Pitt’s good looks (according to PMG internal research results).

Let’s see if we can add an image of Brad’s himself into the graph. Even better, let’s change the actual data points to be represented by his photo (he deserves it).

Steps are pretty simple:

  1. Find an image online and save it in your folder

  2. Go to Insert – Pictures – Select image from your saved location and import the image into your sheet

  3. Change your Chart Type to a Line with Markers. To do that, Select your graph, go to Chart Tools – Design and Click on Change Chart Type.

4. Select Line with Markers option

You should have below graph ready to be transformed into Brad’s world.

5. Click anywhere on the line, right click and select Format Data Series. Under Line options pick No Line.

6. Click  on the actual image in your excel file and Select CTRL+C (or copy). Click on the graph markers and CTRL+V (or paste). Boom!!!

You can do little things, like add data labels and delete vertical lines for a cleaner look.

You can also select individual markers for unique pictures. Then you would copy and paste them one by one for something like below.

Adding Brad’s image in the plot background is just as easy.

Stay in touch

Bringing news to you

Subscribe to our newsletter

By clicking and subscribing, you agree to our Terms of Service and Privacy Policy

You are welcome ladies and gentlemen!

Related Content

thumbnail image

AlliCampaigns & Client WorkData & TechnologyStrategyDigital MarketingCompany News

PMG’s Predictive Dashboard Wins Innovation Award

1 MINUTE READ | September 28, 2021

thumbnail image

Consumer TrendsSocial MediaPlatforms & MediaDigital Marketing

What You Need to Know About Facebook’s Latest Content Transparency Reports

4 MINUTES READ | August 30, 2021

thumbnail image

Consumer Trends

The Road to Recovery for the Travel Industry

5 MINUTES READ | November 19, 2020

thumbnail image

EMEA Search Trends Amid COVID-19

8 MINUTES READ | April 28, 2020

thumbnail image

A Permanent Shift Into Retail Media

1 MINUTE READ | April 23, 2020

thumbnail image

Social eCommerce is The Darling of Cyber Weekend

4 MINUTES READ | December 2, 2019

thumbnail image

Working with an Automation Mindset

5 MINUTES READ | August 22, 2019