The histogram

The histogram shows a numeric value (the Y axis) against a distinct value (the X axis). The height of each column represents the value of the Y axis value.

 

A few points about the histogram:

  • The X axis can be any kind of data, as long as they are distinct
  • The Y axis must be numeric data (otherwise comparison is impossible), only SharePoint numeric list columns (include currency columns) are available for Y
  • The histogram supports multi-series, meaning multiple sets of columns can be rendered in the same graph
  • The histogram 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 histogram (see below example live):

single-series-histogram

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

multi-series-histogram

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 histogram’s Y axis will begin at 20 and end at 80.

visual-range-histogram

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.

Sorting

Data on the histogram can be sorted:

histogram-sorting

In the case of multi-series, sorting on the Y axis will only apply to the last (most recent) added data series. Sorting on the X axis is not affected by multi-series.

histogram-sorting-multi-series

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