The Time Series chart is used to represent data points on a monthly, quarterly, or yearly basis on a Time Based sheet. You can visualize the progress of the company or organization made over time. In OnPlan, time charts are used in statistics for the organization or company.
Each data point on the chart corresponds to both a time and a quantity. The X-axis shows the time period, while the Y-axis shows quantity.
Time Series charts are of three types Line, Bar, and Area. Let's view them in detail.
Line chart
A Line chart represents information as a series of data points connected by a continuous line. It is the basis chart used in financial models.
Let’s add a Line chart to the ‘Test’ model showing Capacity by Employee.
Select Modify Axis, and choose the CHART TYPE as Line. Choose Stacked, or Not Stacked option using the toggle button. Select the "+" button at the bottom of the chart panel. Select the toggle button for Employee 1, Employee 2, and Employee 3.
.gif)
You can see, a line chart with the data points for Employee 1, Employee 2, and Employee 3 in the form of a continuous line.
Bar chart
A Bar chart is a graphical representation of data using rectangular bars arranged in vertical position and the height is proportional to the values present on the Y-axis.
You can add a Bar chart in the similar way as adding your first chart in a model.
Area chart
An Area chart is similar to the Line chart; however, the only difference is each area between the line segments and the X-axis is filled with colors.
Let's add an Area chart to the 'Test' model showing Capacity by Employee.
Select Modify Axis, and choose the CHART TYPE as Area. Choose Stacked to arrange your chart in proper order. Select the "+" button at the bottom of the chart panel. Select the toggle button for Employee 1, Employee 2, and Employee 3.
.gif)
You can see, an area chart representing a particular area filled with color for each data point Employee 1, Employee 2, and Employee 3, respectively.
Did this answer your question?