Area Chart

Area Chart

An area chart visually illustrates the magnitude and proportion of quantitative data changes over time or intervals. Data points are connected with lines, and the space between the lines and the x-axis is filled, providing a clear representation of trends and relative contributions.

How to create an Area Chart:

• First, you need to go to the Visualization pane in Report V2 and select the Area Chart option.

• Now in the Build panel go to the X-Axis section and Choose or Drop the desired Dimension column(Date or Categorical column).

For eg: You need to create a Sales Monthly Trend report using the OrderDate column then you need to select the "OrderDate" column in X axis section and click on the dropdown to choose the Month date function to be applied to the "OrderDate" column.

• Now Y-Axis section you need to select the relevant Measure columns with desired Aggregation functions such as Sum of Sales, Count of Orders, etc wrt which you want to plot the Area Chart.

• Then Click on the Run Button and your Area Chart will be ready.

In Report V2 Area Chart has two panels Build and Format.

Build

This panel is like a building block for the Area Chart. It allows you to select various Dimension and Measure columns for creating the Area Chart.

It is further divided into 3 parts:

Chart Settings: This allows you to select the relevant Dimension and Measure Columns.

• X-Axis: Here you can select only 1 Dimension Column (Date or Categorical) against which you need to plot the Area Chart in the X-axis.

• Y-Axis: Here you can select 1 or more Measure Columns which you need to plot in the Area Chart.

• Category: Here you can select any 1 dimension column to further divide the Area Chart into different categories each with their separate Area trends.

For eg: You have created an "Overall Quarterly Revenue Trend" and now you want to see the "Quarterly Revenue Trend" for each product category then you can easily achieve that by selecting the Product Category column in the Category section and Clicking Run Button. You will now have an updated Area Chart showcasing Quarterly Revenue trends for each product category represented by separate Area trends.

Row Limit: This allows you to limit the Output rows by going to the Row Limit section in the Build panel then selecting the number of rows and clicking on the Run Button.

Sort: This allows you to Sort the report based on certain columns. Go to the Sort option at the bottom in the Build panel then choose one or more columns along with the order Ascending or Descending and then click on the Run button.

Format

This panel allows you to apply various formatting techniques on the Area Chart to make it more customized as per your need. It consists of various different sections which are as follows:

Title: This allows you to give a Title to the Area Chart. You just need to go to the Title section in the Format panel, enter the title and click Apply button.

Legend: This allows you an option whether you want to showcase the chart legend in your Area Chart or not with the help of a toggle button. By default it is disabled. But you can easily enable it by clicking on the Show Legend toggle button.

How to enable and show Legend in your Area Chart:

• First, you need to go to the Legend section in the Format panel and enable the Show Legend toggle button.

• A new dropdown will open up.

• You then need to select the Legend Type: Plain or Scroll. (Plain when you have less number of legends like 2-4 and Scroll when you have a large number of legends like more than 4).

• Font Size: This allows you to choose the font size of the Legends to be shown in the Area Chart as per your need.

• Font Weight: This allows you to decide the appearance of Legend's font in the Area Chart. You can choose either Normal or Bold.

• Font Style: This allows you to choose the font style for Legends' font in the Area Chart. You can choose either Normal or Italic.

• Font Family: This allows you to choose the font family for Legends' font in, the Area Chart. You can choose from a set of different Font Family as per your need.

• Icon: This allows you to choose the icon appearing alongside the Legends in the Area Chart. You can choose from a set of different Icon types like Circles, Triangle etc as per your need. Then Click on the Apply button to reflect the changes.

X-Axis: This allows you to name the X-axis and showcase the axis labels. It has the following components:

• Name: Here you can give the name for the X-axis in the Area Chart.

• Name Gap: This allows you to decide how far below the X-axis the name should appear.

• Name Label: This allows you to decide the format of a name given to the X axis like font size, font type, and font family, etc.

• Axis Label: This allows you to enable/ disable the axis labels in the Area chart. By default it is disabled and you can easily enable it by clicking on the Show toggle button and then choosing the relevant font format for the axis labels to be displayed in the Area chart.

Y-Axis: This allows you to name the Y-axis and showcase the axis labels. It has the following components:

• Name: Here you can give the name for the Y-axis in the Area Chart.

• Name Gap: This allows you to decide how far left the Y axis the name should appear.

• Scale: It allows you to choose the Y-axis scale as per your requirement and data values. You can choose either Linear or Logarithmic scale.

• Scale Start: Here you need to select the starting point for the Y-axis scale.

• Scale End: Here you need to select the endpoint of the Y-axis scale. Position: Here you can choose the position of Y axis like whether you want to show the Y-axis scale on LHS or RHS.

• Name Label: This allows you to decide the format of the name given to the Y axis like font size, font type, and font family, etc.

• Axis Label: This allows you to enable/ disable the Y-axis labels in the Area chart. By default it is disabled and you can easily enable it by clicking on the Show toggle button and then choosing the relevant font format for the axis labels to be displayed in the Area chart.

Data Colors: It allows you to select the desired color for showcasing the data points in the Area Chart as per your need.

By default, it has a blue color assigned and you can change it by clicking on the Data Colors section in the Format panel then choosing the measure column for which you want to change the color, and finally selecting the color and clicking on Apply button.

Data Labels: It allows you to enable/disable the visibility of data labels in the Area chart. By default, it will be disabled. It has the following components:

• Rotate: It allows you to rotate the data labels with respect to the data points as per your need. You can values between 0 to 90 depending upon at what angle you want to rotate the data labels.

• Align: It allows you to adjust the horizontal alignment of data labels with respect to the data points. You can select either of these three Right, Center, and Left alignments.

• Vertical Align: It allows you to adjust the vertical alignment of data labels with respect to the data points. You can select either of these three Top, Middle, and Bottom alignments.

• Position: It allows you to adjust the position of data labels with respect to the data points. You can adjust the relevant position by choosing the correct position from the dropdown menu as per your need.

• Distance: It allows you to adjust the distance between the data labels and data points as per your need. It helps in case you have too many overlapped or congested data points in your Area Chart as you can easily increase the distance value so that the data labels will have more space and becomes more visible.

Stack: It allows you to enable/disable the stacking of various trend areas over each other in the Area Chart.

Data Zoom: It allows you to zoom in on the report output as per your need. It is disabled by default so you need to enable it first if you need to zoom in on your report.

It has the following components:

• Slider: It allows you a slider functionality using which you can scroll through the zoomed-in version of your report(Area Chart). If it is not enabled then you can only view a static zoomed-in part of your report output.

• Start %: It allows you to set the starting point of your Area Chart report from where you want to zoom in.

• End %: It allows you to set the end point of your Area Chart report up to which you want to zoom in.

For eg: If you have created an Area chart that has too many X-axis data points resulting in an overcrowded Area chart and now you want to zoom in to see the proper trend in the 2nd quarter of the chart you can easily do that by passing the Start % value as 25 and End % as 50 and click on Apply button. You then will have a zoomed-in version of your Area chart showcasing the 2nd quarter trend.

Grid Offset: It allows you to adjust the chart grid as per your need. It has 4 offset types: Right, Left, Top, and Bottom.

Field Formatting: This allows you to format field values in selected measure columns as per your requirement. It involves changing the field values like the field value's display units, the number of decimal places, adding any prefix or suffix, etc.