Google Sheets

The heart of every great chart is the data used to create it, but you will not always have the data ready. Using Charts, you can use one of our sample charts, browse the Social Explorer database, access the FRED data, or upload a CSV file from your computer. 

Charts also makes it easy to create a new chart using data in a Google Sheets document.

  1. Go to Home.
  2. In the upper-right corner, click the add icon .
  3. Select Google Sheets.
  4. Click the dropdown menu to select the Google Sheets file you want to load data from.
  5. Click the worksheet drop down menu to select a particular worksheet if applicable.
  6. At the top of the page, click LOAD.
  7. In the Name field, type in the name of your chart.

    If needed, you can change the column data type as well.

  8. Click Next.
  9. Click one of the recommended chart types, or select a chart type you want to use.
  10. Click Next.

    ​Before actually creating the chart, you can preview it in the Preview window. If your visualization doesn’t look the way you expected, you can try transposing the data. You can even go back to the previous windows if the transpose feature doesn't help.

  11. When you're happy with the chart preview, click CREATE CHART.