Bar charts are used to present summarized data, represented as vertical bars, drawn (plotted) on a single or dual scale. The relative “amount” summarized in and represented by each bar determines the height of the bar relative to the other bars and the Y-axis (vertical) scale. An example of a bar chart is presented in the image below.
X-AXIS – Progression of time from earliest (left) to most recent (right). Often, the values across the width of the X-Axis represent the grouping field that was used to categorize records for purposes of graphic presentation of data within each group of records. In the example above, the Group field is the month of the date of the invoice transaction.
Y-AXIS – Progression of value from smallest (bottom) to largest (top)
SCALE – The change (delta) in value as there is a change in time. Often referred to as “Rise-Over-Run” this refers to the change in the height (rise) of each bar (information element) as one progresses (runs) through time from left to right across the X-Axis.
LEGEND – Graphic and textual indication of what data content and mathematic or statistical transformation was applied to the data to determine the height of each bar. In the example above, the Legend tells us that the data used to compose the information in the chart is Invoice data and the transformation is Summation (Total) of the Invoice Amount field
BARS – Each bar represents a grouping of data (in the example above, Grouping is by Month of Invoice Date) that has been mathematically and/or statistically transformed into information. The taller the bar rises above the X-Axis, the greater the positive number represented by the bar itself. In cases where negative numbers are represented, this will be done so using bars that extend downward starting at the X-Axis. When a bar is displaying negative values (values less than zero), the farther the bar descends below the X-Axis, the greater the negative value that is being represented.
To the right of the chart itself, Ninox presents options that users may use to alter or edit the composition and/or presentation of the chart itself. This pallet of options is displayed in the image below.
CHART TYPE – Users may display the information contained in the current chart in any one of seven different chart options provided by Ninox. To select a different presentation option, click the radio button to the left of each option name. Once selected, Ninox will redraw the chart in the newly selected format (chart type). Note that some charts may not accurately reflect the content of the current chart as they require different inputs for each axis or may not have any axis at all.
The other Chart Types available are detailed individually in the following sections of this users manual.
DATA SERIES – As noted above, the standard Bar Chart configuration in Ninox is the represent fields (columns) as bars, the value of the groups of data represented by each column as the key to the Y-Axis and the Grouping field for each row (record) across the X-Axis. Users have the option to “flip” this presentation by changing the data series to row (record). When this is done, what was the X-Axis key becomes the grouping field (as represented in the index) and the previous index field becomes the value displayed in the body of the Bar Chart. The same chart displayed in the first image on this page is redrawn in the image below with the Row being the data series.
STACKED – Please see Stacked Bar Chart section of this users manual.
EDIT COLUMNS – Please see Edit Columns section of this users manual.
SAVE IMAGE – Users may save the chart view currently presented on their display as a static graphic image by clicking the [Save Image] button.
Hovering the mouse over any single element in the chart will result in the numeric value represented by that segment, along with the name of the segment appear in an on-screen help window.