Support Centre

Importing data from a spreadsheet into a chart

Renée Meloche
Renée Meloche
  • Updated

Save any *.xlsx or *.csv format (Excel or Google Sheets compatible) spreadsheet to your device and import it into a chart spreadsheet in the Venngage Editor.

A four-column bar chart appears on a red design canvas in the Venngage Editor. The user double-clicks on the chart, and the Chart Menu pane opens on the right-hand side of the screen, shifting the design canvas slightly to the left. The user clicks the Import button above the chart spreadsheet in the Chart Menu panel. A modal opens over the design canvas; the user double-clicks a file in the Downloads folder to import.

 

Select your chart; open the Edit Chart pane by double-clicking the chart or selecting the chart and clicking the "Edit Chart" button in the top toolbar.

Click "Import" to open the modal (box) and choose the *.xlsx or *.csv spreadsheet file you want to import into the chart spreadsheet.

A close-up of the section in the Chart Menu that shows the Import button above the chart spreadsheet. The Import button is highlighted by a dark red box. To the left of the Import button it reads 'Type, copy and paste, or import a file to add data. File formats include xlsx and csv.'

 

Double-click on the file or click "OK"; a modal will appear over the canvas when the import is complete. Click "Close" to continue.

A four-column bar chart appears on a red design canvas in the Venngage Editor. The Chart Menu pane is open on the right-hand side of the screen, A modal is opens over the design canvas; the user double-clicks a file in the Downloads folder to import. The modal closes, and a small pop-up indicates that the Import is complete. The user clicks 'Close' at the bottom of that modal, and the new data appears in the chart spreadsheet in the Chart Menu pane. The user clicks 'Save' in the Chart Menu and the pane closes; the updates to the chart are saved on the design canvas.

 

Click Save in the Chart Menu to save the imported data in your chart.

Change the chart colors from the spreadsheet in the "Data" tab of the Chart Menu or switch to the Settings tab for more chart styling options.

 

The feature(s) discussed in this article is available on the following Venngage subscription plans: Free, Premium, Business and Enterprise.

Curious about upgrading? Compare our plan features side by side.

Start designing!

Was this article helpful?

1 out of 2 found this helpful

Have more questions? Submit a request