The FREQUENCY formula has the following syntax: If you select New Sheet, the histogram will be moved to a new sheet called Chart1 and the histogram will be in the center of the sheet if you select Object in, you can choose to move the histogram to another worksheet.īefore you enter the frequency formula, you need to add a column named Frequency next to the Binary column. Then, you’ll see a Move Chart window asking you to choose where to place your histogram. To move your histogram to another place, you must first select the histogram and click the Move Chart button on the Design tab or the Chart Area contextual menu. Binary underflow: When you want to see the sum of all values, which are below a certain value in the histogram, you can check this option and enter a number.Overflow bin: When you want to see the sum of all values, which are above a certain value in the histogram, you can check this option and enter a specific number.The number of bins: This option lets you specify how many bins you want in the histogram.Bin Width: This option allows you to specify how large each binary should be.Automatic: This option will automatically decide the number of binaries in the histogram.By Category: This option is used when your horizontal categories are in text format. For example, if you have sales data for Smartphones, Computers, and Tablets, and you want to know the sales volume of each item, this option will be of great help.If you want to add or reduce the number of binary histograms, you can select the horizontal axis and the axis option will be displayed in an appropriate panel format. The word “Bins” represents a bar on the histogram.
When you select a histogram bar, the Format Precise pane will provide options to change the width of the gap between the bars. For the Format proper pane, the options on the panel will also change immediately according to your selected area on the histogram.
0 kommentar(er)
