This website uses cookies to ensure you get the best possible experience. See our Cookies Policy.

PMG Digital Made for Humans

Images on Excel Graphs

2 MINUTE READ | June 8, 2016

Images on Excel Graphs

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

You are welcome ladies and gentlemen!

Posted by Val Karkauskas

Related Content

thumbnail image

Get Informed

PMG’s Predictive Dashboard Wins Innovation Award

1 MINUTE READ | September 28, 2021

Get Informed

The Road to Recovery for the Travel Industry

5 MINUTES READ | November 19, 2020

thumbnail image

Get Informed

Facebook Details Approach to Mobile Industry Changes

4 MINUTES READ | August 31, 2020

Get Inspired

Considerations for Reengaging New Online Customers

1 MINUTE READ | April 29, 2020

Get Informed

EMEA Search Trends Amid COVID-19

8 MINUTES READ | April 28, 2020

thumbnail image

Get Informed

A Permanent Shift Into Retail Media

1 MINUTE READ | April 23, 2020

Get Informed

Social eCommerce is The Darling of Cyber Weekend

4 MINUTES READ | December 2, 2019

thumbnail image

Get Informed

Reports of Amazon Clean Room Draws Attention of Advertisers

2 MINUTES READ | September 4, 2019

Get Informed

PMG Shares Thoughts About Rumored Amazon Data Clean Room

1 MINUTE READ | August 28, 2019

Get Inspired

Working with an Automation Mindset

5 MINUTES READ | August 22, 2019