Import Data to Charts
There are 3 different ways in which you can import data for your charts:
Enter Data Manually
This is best if you have a small data to work with.
To do this, input your data manually into the spreadsheet table on the right of the chart window. The input will be reflected immediately on the chart preview.
To remove or add a column or a row, highlight the specific column or row and Right-click for a drop option to appear.
Import From File
If you have an excel spreadsheet in XLS, XLSX, or CSV format, you can import your data files from your computer to the Piktochart editor. To do so, click Import Your Data at the top of the chart table.
A window will appear for you to select your file to open.
If your Excel file (.XLS and .XLSX) is detected to contain more than one sheet, you will be asked to select the correct sheet from which to pull the data for your chart.
Your data contained in these files need to have column and row headers, and at least one column of data.
Import From Google Drive
To import your file from Google Drive, click Dynamic Data at the top of the window, it will open a different tab with a textbox for your Google Spreadsheet URL. Follow the instructions available on the tab on how to obtain your Google Spreadsheet URL.
Your spreadsheet needs to be publicly published before it can be imported. Here's how:
On your Google Spreadsheet: Click File → Publish to the Web. On the popup window, click Start Publishing button to publish your spreadsheet.
If you have multiple tabs on a spreadsheet, you need to select the sheet you wish to publish:
Then, copy the spreadsheet link from your browser address bar
and paste it in the text box on your chart.
What happens if I update the data on Google Spreadsheet?
As the information in your Google spreadsheet is updated, your chart too will automatically update when refreshed - hence Dynamic Data.
It is not required to edit the visual's chart to update the data.
- If your visual is published on the web via "https://create.piktochart.com/output/..." , the data will be updated when you refresh the page.
- If you download your visual as an image or PDF, you'll need to open the Piktochart editor and download a new copy of the visual.
How do I modify my data after importing it to Google Spreadsheet?
When your data is imported from the Google Spreadsheet, you may only modify the data on the Google Spreadsheet alone. It is not possible to modify the data on Piktochart. This is to maintain consistency so the data is always available in one place.