Input Range – Enter the cell reference for the range of data you want to analyze. The reference must consist of two or more adjacent ranges of data arranged in columns or rows. Grouped By – To indicate whether the data in the input range is arranged in rows or in columns, click Rows or Columns.

Where is input range in Excel?

Excel 2013 On a worksheet, type the input data in one column, and the bin numbers in ascending order in another column. Click Data > Data Analysis > Histogram > OK. Under Input, select the input range (your data), then select the bin range.

How do you convert vertical input range?

For Chrome, use -webkit-appearance: slider-vertical . For IE, use writing-mode: bt-lr . For Firefox, add an orient=”vertical” attribute to the html. Pity that they did it this way.