Upload data – Charts

The heart of every great chart is the data used to create it. However, you might not always have the data ready. Using Charts, you can use one of our sample charts, try sample, upload as a CSV file from your computer, import data from Google Sheets, access FRED data, access data from Statistics Canada, or browse the Social Explorer database.

Try sample

If you want to try out a chart which contains sample data follow these steps:

  1. Open project in Vizualist dashboard, select Charts aplication.

  2. In the upper-right corner, click the add icon .

  3. Select Try sample.

  4. Choose a sample chart from the list.

  5. Click on Try the sample.​

Upload data

Charts allows you to upload data and create interactive charts. To do so, please follow these steps:

  1. Open project in Vizualist dashboard, select Charts aplication.

  2. In the upper-right corner, click the add icon .

  3. Select Upload Data.

  4. Click on browse or drag and drop your data.​

  1. In the Name field, type in the name of your chart.

  2. Choose a chart type.

  3. Click on Next.

  4. Preview your chart and click on Create chart.

Google Sheets

To import data from Google Sheets, please follow these steps:

  1. Open project in Vizualist dashboard, select Charts aplication.

  2. In the upper-right corner, click the add icon .

  3. Select Google Sheets.

  4. Select your Vizualist account.

  5. Click on Allow.

  6. Choose a spreadsheet that you would like to import.

  7. Click on Load.

  8. In the Name field, type in the name of your chart.

  9. Choose a chart type and click on Next.

  10. Preview your chart and click on Create chart.

Federal Reserve Economic data (FRED)

To import data from FRED (Federal Reserve Economic data), please follow these steps:

  1. Open project in Vizualist dashboard, select Charts aplication.

  2. In the upper-right corner, click the add icon .

  3. Select FRED (Federal Reserve Economic data).

  4. Type in a series name or series ID and search for FRED data.

  5. Select the series you would like to have within your chart.

The following options allow you to tweak your series:

  • Click on the dropdown menu under “Units” to choose the unit you would like to have.
  • Click on “Find a data series” to have multiple series in your chart.
  • Click on “Formula” to create a formula to calculate the series.
  • Select the dropdown menu under “Frequency” to determine the frequency of the data for the chart.
  • Select the dropdown menu under “Observation range” to determine when the observation will start. You will be able to choose a date or quantity for the period.

  1. Click on “Done”.

  2. Have a final review of the series you created for your chart.

  3. Click on “Load”.

  4. In the Name field, type in the name of your chart.

  5.  Have a final review of your data and click on “Next”.

  6.  Choose a chart type and click on “Next”.

  7.  Have a final review of your chart and click on “Create Chart”.

Statistics Canada​

  1. Open project in Vizualist dashboard, select Charts aplication.

  2. In the upper-right corner, click the add icon .

  3. Select “Statistics Canada”.

  4. Type in a vector ID and search for Statistics Canada data.

  5. Select the vector you would like to have within your chart.

  6. The following options allow you to tweak your vectors:

  • Click on “Name” to change the name of your vector.
  • Click on “Find a vector” to have multiple vectors in your chart.
  • Click on “Formula” to create a formula to calculate the vectors.
  • Select the dropdown menu under “Observation range” to determine to determine when the observation will start. You will be able to choose a date or quantity for the period.

  1. Click on “Done”.

  2. Have a final review of the vectors you created for your chart.

  3. Click on “Load”.

  4. In the Name field, type in the name of your chart.

  5.  Have a final review of your data and click on “Next”.

  6.  Choose a chart type and click on “Next”.

  7.  Have a final review of your chart and click on “Create Chart”.

Social Explorer

Social Explorer is a platform containing demographic data from various sources. Data is available through custom made reports and some of them include US Census data, American Community Survey (ACS) data and Election data.

Using Social Explorer data integration you can access comprehensive demographic data on different geography levels and compare data across states, counties and other geography levels.

  1. Open project in Vizualist dashboard, select Charts aplication.

  2. In the upper-right corner, click the add icon .

  3. Select Social Explorer.

  4. Choose a survey and year.

  5. Choose a dataset.

  6. Add variable/s.

  7. Select variable/s.

  8. Click on Done.

  9. Add geography.

  10. Select geography/ies.

  11. Click on Load.

  12. In the Name field, type in the name of your chart.

  13. Click on Next.

  14. Choose a chart type.

  15. Click on Next.

  16. Preview your chart and click on Create chart.