How to Use the Data Editor for Charts and Graphs?

Data Editor is the single most powerful tool that you can use to enter the data, select a chart type, and publish your chart. Several features allow you to customize the entire chart any way you like. 

But first, let’s take a quick walkthrough of the salient features of Data Editor:

Chart Type

This is where you can select from a range of charts available in the Charts and Graphs Plugin.

Note: Only Column Chart is available in the basic version. 

Here are the types of charts you can select from:

• Column Chart
• Line Chart
• Pie Chart
• Bar Chart
• Area Chart
• Stacked Chart
• Doughnut Chart
• Semi Circle Doughnut Chart
• Pyramid Chart
• Funnel Chart
• Radial bar
• Spiderweb
• Radar
• 3D pie chart
• 3D Donut chart
• 3D Column Chart
• 3D Stacked Chart
• 3D Cylinder Chart
• 3D Funnel Chart
• 3D Pyramid Chart

Here is the Dashboard for Charts & Data from where you can access your preferred chart type.

Now, let’s move on to Data Editor.

Here, you need to select your Data Source. You can either proceed with Static Data or Dynamic URL. We have already covered How to import data through a Dynamic URL (Google Sheets) in the following tutorial: 

How to connect your chart to a CSV file in Google Drive.

Let’s get started with Static Data 

In the following screenshot, what you see is the data range where you can input data in rows and columns, which then translates to a chart.

To add a row, click the plus icon at the bottom of the table, and to add a column, click the plus icon at the right of the table.

Think of it as a basic version of Excel. Adding and managing data is quite easy. We have created dummy data depicting the Sales Revenue, Expenses, and Net Profit for each month. Note that if you have a figure in the negative range, Charts Ninja will automatically adjust itself to display it.

As always, save your changes and hit the Preview button at the top right to preview your graph:

Here is how the graph with positive and negative figures would look like:

If you want to change the colors of each data, go to Data Editor and click the small icon next to the label you want to change. You can now select from any color to match your preferences: