Marimekko chart of Facebook and Google spend by each presidential candidate for week of March 3-10, 2019.

Presidential Candidates Social Media Spend

The presidential candidates spend over $1.4M on Facebook and Google for the week of March 3-10, 2019. President Trump outspent his challengers, as shown in this Marimekko chart.  His campaign accounted for about 40% of the total Facebook spend and 2/3 of the total Google spend. Spending data was compiled by Bully Pulpit Interactive.

Most candidates followed President Trump's lead and divided their spending between the two platforms.  The biggest exceptions were Beto O’Rourke, Bernie Sanders and Kirsten Gillibrand.  They relied almost solely on Facebook.  Pete Buttigieg, in contrast, spent his social media budget entirely on Google.

Presidential Candidates Social Media Spend in a Marimekko Chart with Data Row

Marimekko chart of Facebook and Google spend by each presidential candidate for week of March 3-10, 2019.

How I Made This Marimekko Chart with Data Row

I downloaded the data from the web into an Excel file and to create a PivotTable from the file as shown below:

Data for Marimekko chart of Facebook and Google spend by each presidential candidate for week of March 3-10, 2019.

  Here are the steps to make the Marimekko chart with data row:

  • create a chart in PowerPoint based on the selected data from the PivotTable and data row as shown above
  • exclude the total rows and columns from the data included in the Mekko Graphics Data Editor
  • use data scale to divide numbers by one thousand
  • add $ sign as prefix and K as suffix to segment values, bar totals and grand total
  • show % of total row as a data row
  • add a computed column for the percentage each candidate spend on Facebook
  • categorize in another column the candidates with 2/3 or more spend on Facebook, 2/3 or more spend on Google and mix of spend
  • do not show these last two columns in the chart
  • use Bars and Series dialog to set colors for the three spending categories
  • add legend, hide all but three legend items (one for each category), manually edit legend labels for those three items
  • annotate segment labels for smaller segments
  • add x axis title
  • move data row to show above x axis title
  • adjust internal chart margins
  •  

Take This Chart and Make It Your Own

Download this chart and edit it using Mekko Graphics. See more Marimekko charts in our chart gallery. Here are some other charts that may be of interest: