3 Easy Ways to Insert Data while Charting with PlotSet

3 Easy Ways to Insert Data while Charting with PlotSet

Data Visualization
author
PLOTSET TEAMAPR 24, 2023
2 min
101

When charting in PlotSet, the first thing you need to do is insert your data. Let's review the steps you should follow:

In the charting area, hit the "Change Data" button.

/uploads/Frame_676_655e8f6a9f.png

Now, you may insert your data in 3 different ways.

1. Insert data manually

/uploads/Frame_677_85a48410bb.png

You can enter your data here manually as you do so when filling in Google Sheet cells. This method would be suitable when dealing with a limited number of data points. As you probably guessed, entering data manually would not be practical for huge data sets. 

Right-click on each cell to see the customization options, which enable you to add columns or rows, sort the columns, or delete the extra ones.

2. Upload Data Sheet File

/uploads/Frame_678_0324e5d41e.png

You can directly upload a Google Sheet file or a CSV from your PC. Just choose your file and hit "Upload."

3. Import Data from Online Google Sheet

/uploads/Frame_679_a2a25809a6.png

In this method, copy-paste the link to your Google Sheet in the right field and then import your data. Make sure to enable general access to "Anyone with the link."

Note: In case your Google Sheet contains more than one tab, make sure to write the name of that tab here in the Advanced Options.

/uploads/Frame_680_329b28bb0d.png

If you wish to display specific columns in your data sheet, mention the column names in the "Range" field.

/uploads/Frame_681_ab1441c657.png

Bonus point

In certain charts, like Bar Chart and Split Bars, where you have the option to add pictures to the template, you should insert the links to the pictures in a separate column. Then, write the name of that column in the "Images" field. Afterward, in the "Value" field, write the column number where the dataset starts (here, it starts from Column C).

/uploads/Frame_663_1_3e99d49048.png

Knowing these simple tricks helps you navigate your data more efficiently in the plotting area.

If you like to know more about data visualization, read the following blog: Why Data Visualization Is Important

Recent Posts
AI Generates Most of What You Read Online
AI Generates Most of What You Read Online
Nov 3, 2025
Animated charts made me famous. Now they’re yours
Animated charts made me famous. Now they’re yours
Sep 29, 2025
10 Prompts for Stunning AI-Generated Charts Using Prompt To Data
10 Prompts for Stunning AI-Generated Charts Using Prompt To Data
Dec 11, 2024
Introducing the "Prompt to Data" Feature
Introducing the "Prompt to Data" Feature
Dec 5, 2024