How to Add Charts to Email Newsletters

If you've ever tried to jazz up your email newsletter with a live chart or slick embed code, you know the pain: broken images, sad little “click to view,” or (worst of all) a blank space where your hard work should shine. Unfortunately, email clients like Apple Mail, Gmail, and Outlook are allergic to fancy embedded code and JavaScript. Only one thing will work: good old-fashioned images.

These tips will help you find the frustration-free way to get your data into subscribers' inboxes.

Broken chart in email

Why You Can't Just “Embed” Charts in Emails

How Big Should My Chart Image Be?

a resized chart
An email chart that has been improved by increasing the font size

Easy Methods for Making Email-Ready Chart Images

1. SnappyCharts

If you use SnappyCharts, you're a few clicks away from inbox perfection:

  1. Create or open your chart in SnappyCharts.
  2. Click the Download image button above your chart.
  3. From the dropdown, pick Small image, which is sized just right for email newsletters.
  4. Upload the image into your newsletter builder (Mailchimp, Substack, ConvertKit, etc.) or drag it into your message as you would any image.

Pro tip: SnappyCharts automatically optimizes images for email—no cropping or resizing required. Just bump up the font size a bit if needed.


2. Google Sheets

Have you built your chart in Google Sheets? Here's how to export it for your newsletter:

  1. Click your chart to select it.
  2. Click the three-dot menu (top-right of the chart) and choose Download.
  3. Select PNG image.
  4. Insert the image into your email just as you would any picture.
  5. You may need to adjust the size of the chart within your document and export it again to achieve a suitable size.

3. Excel

Here's how to wrangle a newsletter-ready chart image from Excel:

  1. Create your chart and select it.
  2. Right-click and choose Save as Picture.
  3. Select a PNG or JPEG file.
  4. Drop the image into your newsletter.
  5. If the size isn't working, you may need to adjust the layout and save the image again.

Bonus Pro Tips