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):
Here is an example of a multi-series histogram (see below example live):
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.
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.
Please note, the visualizer will take into account both range user inputted and the data range from data, and use the most inclusive range.
Data on the histogram can be sorted:
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.