Nuts and Bolts: Embed Charts and Tables in WordPress and Core Publisher

After you get your chart or table into Google Drive and formatted the way you’d like to, follow these steps, kindly collected by data viz maven Emilie Ritter Saunders, to get it into your post:

Embedding Charts in WordPress

  1. Make your chart public to the web: Share —-> Change “public on the web”
  2. Publish your table: Click the arrow dropdown (upper right corner of the chart) —-> Select a chart1publish format “Image.”
  3. Copy that “Image” code and paste it into the HTML side of your WordPress editor.

Embedding Tables in WordPress

  1. Make your table public to the web: Share —-> Change “public on the web”
  2. Publish your table: File —-> Publish to the web —-> Click Publish or Republish Now
  3. Copy the URL.
  4. Paste the URL into the spreadsheet function in WordPress, “Google Spreadsheet Key.”
  5. Add your source information, if your table has more than 25 rows select “paginate.”
  6. Click “Insert.”

Embedding Charts in CorePublisher

Charts are not yet embeddable in CorePublisher the way they are in WordPress, but you can get around this hangup by saving your chart as an image, and then uploading that image into CP the same way you’d add a photo.

Embedding Tables in CorePublisher

Tables are embeddable in CorePublisher, but you don’t have pre-formatted options the way you would in WordPress.

  1. Make your table public to the web: Share —-> Change “public on the web”
  2. Publish your table: File —-> Publish to the web —-> Click Publish or Republish Now
  3. Keep the Publish to the web screen open and “get a link to the published data.”
  4. Change the dropdown that says “web page” to “HTML to embed in a page.”
  5. Copy that HTML embed code.
  6. Paste the code on the HTML or “source” side of your CorePublisher site
  7. The default size is 500×300, I’d recommend making that larger, 600×400. You can change that directly in the code in Google Drive, or you can change it once you paste into CorePublisher.
  8. Because CP doesn’t have a pre-formatted “source” option, I’d add where you got the data below the table.

Comments are closed.