> For the complete documentation index, see [llms.txt](https://docs.fabricplan.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.fabricplan.com/documentation/plan/intelligence-sheets/how-tos/apply-ibcs-formats/area-and-line-charts.md).

# Area and line charts

IBCS area and line charts help visualize trends, patterns, and changes over time using standardized layouts and semantic formatting. Use these charts to track business performance, compare actual and reference values, and communicate trends consistently across reports.

### C07: Line chart

An IBCS line chart visualizes trends and changes across sequential time periods. It is best suited for tracking KPIs such as revenue, profit, expenses, or inventory over time. Analyze growth patterns, seasonal trends, and changes in performance.

<table><thead><tr><th width="252.5">Configuration option</th><th>Configuration value</th></tr></thead><tbody><tr><td><strong>Chart type</strong></td><td>Line</td></tr><tr><td><strong>Category</strong></td><td>Assign the dimension that defines the columns along the x-axis. <em>Example: Month</em>.</td></tr><tr><td><strong>Actual(s)</strong></td><td>Assign one or more measures to analyze. The values determine the position of each data point on the y-axis, and the connected points form the trend line. <em>Example: Profit - Actual</em>.</td></tr><tr><td><strong>Comparison 1 (vs Actuals)</strong></td><td>Assign the previous year's actuals measure for comparison. The chart displays the comparison measure as a second line chart. <em>Example: Profit - Prior Year.</em></td></tr><tr><td><strong>Comparison 3 (vs Actuals)</strong></td><td>Assign a forecast measure for comparison. The chart displays the comparison measure as a dotted line for the forecast period. <em>Example: Profit - Forecast.</em></td></tr></tbody></table>

<figure><img src="/files/adaWqsbgAgyOMYEbF6DI" alt=""><figcaption></figcaption></figure>

1. In the **Line** ribbon, select **Series**. Deselect the variance series to show only the line chart.

<figure><img src="/files/B3DdigVTNNgm7u2DoAA2" alt=""><figcaption></figcaption></figure>

2. Select **Deviation** > **Customize** > **Display** and select **Create your own**. Select **Apply**, then select the points to plot the deviation.

<figure><img src="/files/0V4qOEfn6vzXevGQfMXK" alt=""><figcaption></figcaption></figure>

3. To customize the series colors, in the chart ribbon (in this example, **Line**), go to **Settings** > **Canvas** > **Category format** and select the colors to apply.

<figure><img src="/files/1EP1mrY8DRlpzu5Eahac" alt=""><figcaption></figcaption></figure>

### C08: Area chart

IBCS area charts emphasize the magnitude of values while showing trends over time. The shaded area highlights cumulative values, making it easier to compare the overall volume of business metrics such as sales, cash flow, or production. Use this chart when both trend and magnitude are important to the analysis.

<table><thead><tr><th width="252.5">Configuration option</th><th>Configuration value</th></tr></thead><tbody><tr><td><strong>Chart type</strong></td><td>Stacked area</td></tr><tr><td><strong>Category</strong></td><td>Assign the dimension that defines the columns along the x-axis. <em>Example: Month</em>.</td></tr><tr><td><strong>Actual(s)</strong></td><td>Assign one or more measures to analyze. The values determine the position of each data point on the y-axis, and the connected points form the trend line. <em>Example: Profit - Actual</em>.</td></tr><tr><td><strong>Legend /</strong> <strong>Color by / Stacked</strong></td><td>Assign a dimension to split the measure into separate series. Each category is plotted as a distinct area chart, and the area charts are stacked to show the cumulative total. <em>Example: Region.</em></td></tr></tbody></table>

<figure><img src="/files/mmE86NO5wLkFGXITv0H8" alt=""><figcaption></figcaption></figure>

To customize the series colors, in the chart ribbon (in this example, **Stacked area**), go to **Settings** > **Canvas** > **Stack groups** and select the colors to apply.

<figure><img src="/files/UpDe8oeQ7aoQOB5XMkod" alt=""><figcaption></figcaption></figure>


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://docs.fabricplan.com/documentation/plan/intelligence-sheets/how-tos/apply-ibcs-formats/area-and-line-charts.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
