29.4.14 Frequency Chart

Frequency Chart 01.png

Data Requirements

Select at least one column to count unique values, and create column/bar/pie/doughnut/sunburst plot.

Creating the Graph

Select required data.

From the menu, choose Plot > Bar, Pie, Area: Frequency Chart. The dialog plot_frequency will pop up.

The "plot_frequency" dialog box

Frequency Chart 02.png

Input Choose at least one column as source data to calculate and plot the frequency chart.
Frequncy Choose one column or columns as frequency data as optional input.

When Multiple Data is set to Separate Graphs, this option allows multiple columns to be selected as frequency data. The number of columns could be 1 or same as the number of Input columns.

  • When you selected only one column for this option, then every input column will take this column as frequency.
  • When you selected multiple columns for this option, each input column will take one selected column as frequency data in order. And, the Y value is the sum of frequency data by input category.

When Multiple Data is set to Nested Count in Same Graph, this option only allows one column to be selected.

Multiple Data Specify how to plot the selected multiple data columns.
  • Separate Graphs: Plot the multiple input columns into separate graphs.
  • Nested Count in Same Graph:Count the nested counts of last input column based on all selected columns, and then plot them on the same graph.
Split Panels by Once this check box has been checked, you can select another grouping column to enable horizontal panels which show a frequency chart for each grouping value seperately. Wrap Panels will be enabled, ticks and labels will be shown on alternate sides by default.

When there are multiple columns selected, only one panel info label row will be shown on top, panel banner string will include all factors and separated by comma; Meanwhile, if Multiple Data is set to Nested Count in Same Graph, this option will be hidden.

Split Pages by Once this check box has been checked, you can select another grouping column to split the input data and created frequency column chart in different graph pages. Each page only plots the columns within the same page related group. Page related group info will be shown in layer title, separated by comma if there are multiple factors. Report graph sheet will list all pages.
Plot Type Choose a plot type to present the frequency of the source data.
  • Column
  • Bar
  • Pie
  • Doughnut: Only for multiple input columns and Multiple Data is set to Separate Graphs.
  • Sunburst: Only for multiple input columns and Multiple Data is set to Nested Count in Same Graph.
  • Sunburst with Hole: Only for multiple input columns and Multiple Data is set to Nested Count in Same Graph.
Share Y This option only shows when multiple source data columns have been selected for Input box and Multiple Data has been set to Separate Graphs for Column or Bar plot type. It is used to make the Y scale shared between different graphs.
Stack The control is only avaliable when there are multiple input data, Multiple Data has been set to Nested Count in Same Graph and Plot Type has been set to Column or Bar.

Specify how to plot the nested count as columns/bars. There are three ways to present the count as columns/bars:

  • Side by Side
  • Stacked(Last Column)
  • 100% Stacked(Last Column)
Graph Template This option will show default template to create the different plot types. You can uncheck Auto box to choose another template, such as user-defined templates.
Output Plot Data Specify which sheet the plot data will be outputed to.
Output Graphs Specify which sheet the result graphs will be outputed to.

Template

column.otpu
bar.otpu
Pie2D.otpu
Doughnut.otpu
(installed to the Origin program folder).

Notes

If the selected category columns includes missing values, you can use the system variable @CATS to exclude them.

English | Deutsch | 日本語