Creating Area Charts in Apache Superset

  

An area chart is a type of data visualization that shows how values change over time while also emphasizing the magnitude of those values. It is basically a line chart with the space under the line filled with color.

 

What makes it useful?

An area chart helps you understand two things at once:

·      Trend direction (like a line chart)

·      Volume or size of the values (because the filled area shows magnitude)

 

If you plot sales over time:

·      A line chart shows whether sales are going up or down

·      An area chart shows how much sales you had over time in a more visually impactful way

 

Key characteristics:

·      X-axis usually represents time (day, month, year, etc.)

·      Y-axis represents values (sales, profit, revenue, etc.)

·      The space under the line is filled with color

·      Can display one or multiple metrics

 

When to use it:

·      To show business trends over time

·      To compare multiple metrics together

·      To highlight overall volume + trend

 

area_chart_data.csv

order_date,sales,profit
2025-01-01,1200,240
2025-01-02,1350,260
2025-01-03,1100,210
2025-01-04,1500,300
2025-01-05,1700,340
2025-01-06,1600,310
2025-01-07,1450,280
2025-01-08,1550,290
2025-01-09,1800,360
2025-01-10,1900,380
2025-01-11,1750,350
2025-01-12,1650,320
2025-01-13,1400,270
2025-01-14,1300,250
2025-01-15,1500,300
2025-01-16,1600,310
2025-01-17,1700,330
2025-01-18,1850,370
2025-01-19,2000,400
2025-01-20,2100,420
2025-01-21,1950,390
2025-01-22,1800,360
2025-01-23,1750,340
2025-01-24,1600,310
2025-01-25,1550,300
2025-01-26,1450,280
2025-01-27,1500,290
2025-01-28,1650,320
2025-01-29,1700,330
2025-01-30,1850,370
2025-01-31,2000,410
2025-02-01,2100,430
2025-02-02,2200,450
2025-02-03,2050,420
2025-02-04,1900,380
2025-02-05,1750,350
2025-02-06,1600,310
2025-02-07,1500,300
2025-02-08,1400,280
2025-02-09,1550,310
2025-02-10,1650,330
2025-02-11,1800,360
2025-02-12,1950,390
2025-02-13,2100,420
2025-02-14,2250,460
2025-02-15,2300,470
2025-02-16,2150,440
2025-02-17,2000,400
2025-02-18,1850,370
2025-02-19,1700,340
2025-02-20,1600,320
2025-02-21,1500,300
2025-02-22,1450,290
2025-02-23,1550,310
2025-02-24,1650,330
2025-02-25,1750,350
2025-02-26,1850,370
2025-02-27,1950,390
2025-02-28,2050,410
2025-03-01,2200,450
2025-03-02,2300,470
2025-03-03,2400,490
2025-03-04,2250,460
2025-03-05,2100,430
2025-03-06,1950,390
2025-03-07,1800,360
2025-03-08,1700,340
2025-03-09,1600,320
2025-03-10,1500,300
2025-03-11,1650,330
2025-03-12,1750,350
2025-03-13,1850,370
2025-03-14,2000,400
2025-03-15,2150,430
2025-03-16,2300,460
2025-03-17,2450,500
2025-03-18,2500,510
2025-03-19,2350,480
2025-03-20,2200,450
2025-03-21,2050,420
2025-03-22,1900,380
2025-03-23,1750,350
2025-03-24,1600,320
2025-03-25,1500,300
2025-03-26,1650,330
2025-03-27,1800,360
2025-03-28,1950,390
2025-03-29,2100,420
2025-03-30,2250,450
2025-03-31,2400,490
2025-04-01,2550,520
2025-04-02,2600,530
2025-04-03,2450,500
2025-04-04,2300,470
2025-04-05,2150,430
2025-04-06,2000,400
2025-04-07,1850,370
2025-04-08,1700,340
2025-04-09,1600,320
2025-04-10,1500,300

   

Follow below step-by-step procedure to build Area Chart.

 

Step 1: Create dataset.

 

Data -> Upload CSV to database

 

Upload CSV file.

Choose the database and schema where you want to upload the csv file.

Give table name as area_chart_demo.

 

Expand Columns section.

 

Select all the columns for the text box 'Columns to read'.

Set Column data types to {"order_date": "datetime64[ns]", "sales": "int32", "profit" : "int32"}

 

Click on Upload button.

 

Navigate to Datasets listing page, you can able to see area_chart_demo dataset.

 

Step 2: Create Area Chart.

 

Click on ‘area_chart_demo’ dataset.

 

You will be taken to chart configuration page.

 

Click on ‘View all charts’ link.

 

Select Area Chart.

 

Drag and drop order_date column to dimensions.

Drag and drio sales and profit columns to Metrics section. Choose aggregate operation as SUM.

 

Click on Create chart button, you can able to see that Area chart is rendered like below.

 

Go to Customize tab and set X-Axis and Y-Axis titles.

Select the checkbox Extra Controls.

 

You can observe that the chart is changed like below.

 

That’s it, you're good to go.

  

Previous                                                    Next                                                    Home