The area graph

The area graph presents quantitative data over time, similar to line graph. Each data series (each area) is color coded. Commonly used to compare multi-series data (multiple areas).

 

The area graph has the following features:

  • The X axis must be datetime data, when configuring for the area graph, only SharePoint datetime list column are available for X
  • The Y axis must be numeric data (otherwise comparison is impossible), only SharePoint numeric list columns (include currency columns) are available for Y
  • The area graph supports multi-series, meaning multiple area can be rendered in the same graph
  • The area graph supports live data updates from SharePoint, meaning when the underlying SharePoint list data changes, the graph will gracefully update itself

Here is an example of a single-series area graph (see below example live).

single-series-area

Here is an example of a multi-series area graph (see below example live):

multi-series-area

DateTime Grouping

Sometimes instead of plotting datetime data row by row, where each row of data is a dot on the area graph, you want to group datetime data. The visualizer can group datetime data on one of these levels: Year, Quarter, Month, Week, Day, Hour, Minute.

Once datetime data is grouped, the area graph can show one of these values: Minimum, Maximum, Average, Median, Sum, First, Last, Row Count, Unique values.

Consider the following example.

First we have a SharePoint list holding the stock price of Apple Inc from 2007 to 2012.

datetime-grouping-area-data

Now, what if we want to create an area graph, where it shows the “average stock price quarterly“? to do so, use the following configuration.

datetime-grouping-area-config

The result as follows (see the below example live):

datetime-grouping-area-example

Visual range

When rendering, the visualizer will determine the visual range on the Y axis from data, from example, if the minimum and maximum value from your data is 20 and 80, respectively, then the area graph’s Y axis will begin at 20 and end at 80.

visual-range-area

Users have the option to override this range to be a more inclusive range, in the above example, users can set the range to be, say between 0 and 100.

visual-range-area-config

Please note, the visualizer will take into account both range user inputted and the data range from data, and use the most inclusive range.

Area shape

You can adjust the shape of the area in the configuration panel.

area-shape-config

These shapes are supported:

Linear (default)

area-shape-linear

Linear closed

area-shape-linear-closed

Step before

area-shape-step-before

Step after

area-shape-step-after

Basis

area-shape-basis

Basis open

area-shape-basis-open

Basis closed

area-shape-basis-closed

Bundle

area-shape-basis-bundle

Cardinal

area-shape-cardinal

Cardinal open

area-shape-cardinal-open

Cardinal closed

area-shape-cardinal-closed

Monotone

area-shape-monotone

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s