Stacked Area charts show how values change over time while also displaying how individual segments contribute to the total.
They are especially useful when you want to:
- visualize trends over time
- understand cumulative totals
- see how different segments contribute to growth
- analyze overall progression of values
In this tutorial, you will reuse the Sales Tracking list to create a Stacked Area chart that visualizes cumulative monthly sales.
Instructions
Step 1: Prepare the data source
We will reuse the Sales Tracking list.
The list contains:
- Month
- 2025 Sales
- 2026 Sales
- Index
Make sure the view is sorted by: Index (Ascending)
Step 2: Open Charts in Ultimate Forms
- Open Design
- Select Charts
- Click Add new profile
Step 3: Configure General settings
- Title: Monthly Sales Trend (Stacked)
- View: All Items (or your sorted view)
- Category (X axis): Month
- Colors (optional)
- Add two Series:
- Series 1:
- Column: 2025 Sales
- Aggregation: Sum
- Label: 2025
- Series 2
- Column: 2026 Sales
- Aggregation: Sum
- Label: 2026
- Series 1:
Step 4: Configure Display settings
Open the Display tab.
- Chart type: Stacked Area
- Enable 3D - Optional (can be enabled for a more visual effect)
- Show legend: Enabled
- Legend position: Top
- Show values: Enabled (optional)
- Width: 1000
The chart will display filled areas stacked on top of each other, forming a cumulative total over time.
Step 5: Configure Title settings
- Include title: Enabled
- Font size: 16px
- Bold: Enabled
Step 6: Save the chart profile
- Click Save
The Stacked Area chart profile is now available for use.
Step 7: Add the chart to a SharePoint page
After saving the chart profile, you need to add it to a SharePoint page using a web part:
- Create a new SharePoint page.
- Click the + button and add the Ultimate Forms.
- Once added, click the Edit Properties.
- In the web part properties:
- Set Type to Charts
- Select the profile: Monthly Sales Trend (Stacked)
- Publish the page
Result
The Stacked Area chart displays cumulative monthly sales while showing how each year contributes to the total over time.
This makes it easy to:
- identify overall growth trends
- understand how values accumulate
- compare contribution within the total
Compare with Area Chart
What changes:
- Area chart → displays values for each series independently, but overlapping areas may make comparison harder
- Stacked Area chart → combines values into a cumulative total, making overall trends and contributions clearer
Summary
In this tutorial, you learned how to create a Stacked Area chart to visualize cumulative trends and composition over time. This type of chart is ideal for analyzing how values grow and combine across categories.
