• About Us
    • New York
  • Work
  • Capabilities
  • Careers
  • Technology
  • Blog
  • Contact Us
  • About Us
    • New York
  • Work
  • Capabilities
  • Careers
  • Technology
  • Blog
  • Contact Us
June 08, 2016

Images on Excel Graphs

Posted by Val Karkauskas

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).

Capture1

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.

Capture2

4. Select Line with Markers option

Capture3

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

Capture4

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

Capture5

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.

 

Capture6new

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.

Capture7

You are welcome ladies and gentlemen!

 

Previous
Next

Latest White Papers

  • Shifting Plans for 2020 & Beyond
  • Game On: How Brands Can Log Into A Diverse Multi-Billion Dollar Industry
  • What CCPA Means For Brands
  • How Google is Improving Consumer Data Privacy
  • Ways to Prepare for the Cookieless Future
  • See all White Papers

Featured Posts

  • Ad Age Names PMG #1 Best Place to Work in 2021
  • Hindsight 2020 & Looking Ahead to 2021
  • Preparing for Streaming’s Growth & The Future of TV Buying
  • MediaPost Names PMG Independent Agency of the Year
  • PMG Client Portfolio Trends During Amazon Prime Day 2020

Categories

  • Consumer Insights
  • Content
  • Creative Design
  • Data Analytics
  • Development
  • Digital TV & Video
  • Ecommerce
  • Industry News
  • Local
  • Mobile
  • Paid Search
  • PMG Culture
  • Programmatic & Display
  • SEO
  • Social Media
  • Structured Data
Fort Worth

2845 West 7th Street
Fort Worth, TX 76107

Dallas

3102 Oak Lawn Avenue
Suite 650
Dallas, TX 75219

Austin

823 Congress Avenue
Suite 800
Austin, TX 78701

London

33 Broadwick Street
London
W1F 0DQ

New York

120 East 23rd Street
New York, NY 10010

Get in touch

(817) 420 9970
info@pmg.com

Subscribe to the PMG Newsletter
© 2021 PMG Worldwide, LLC, All Rights Reserved
  • Contact
  • Privacy Policy
 Tweet
 Share
 Tweet
 Share
 Tweet
 Share
 LinkedIn
We and our partners use cookies to personalize content, analyze traffic, and deliver ads. By using our website, you agree to the use of cookies as described in our Cookie Policy.