Right-click the histogram row you want to export and select Export to Excel.Click OK to export the information from the histogram graph into Excel.If no templates are displayed, or if the template you require is not displayed, click Look in and browse for the folder containing the template you want.Note that any data that is contained within the selected template is disregarded. This field displays the Excel templates that are located in the folder specified on the File Locations tab of the XLS file in the Select an export template field. Select an Excel template with which to create the.Alternatively, click Browse to search for the location of the file you want to create. If you enter the name of an existing file, you are asked whether you want to overwrite the file or not. You can enter the name of a new file, or an existing one. XLS file to which you want to export the information in the Export file name field. Note that you must right-click the histogram graph precisely on part of the graph in order for this command to be available: if you right-click a blank area of the histogram, the Export to Excel command appears instead, which you use to copy information from all of the graphs in the histogram to Excel. Right-click the histogram graph you want to export and select Export to Excel.if your lower bound value is in cell B1:B30 and the upper bound is in D1:D30, then in cells E1:E30 you will write something like =CONCATENATE(B1,' - ',D1).įrom here, a simple bar chart can be used which will allow a log scale be selected as described in this thread.

I then use a helper column to contain the upper bound value of the bin (simply by referencing the next value in the bin array), then use a concatenate function to create a reasonable value for the x axis of your plot - e.g. in cells B1:B30), then highlight cells C1:C30 and type in the FREQUECNY function then press CTRL+Shift+Enter to complete the operation.

Information about the usage of this function can be found online, but in short if you have your data to be binned in cells A1:A100 then you just need to create your bins array (e.g. then the first row of your results will show the frequency of a value between 20-21, the next 21-22 etc. Your bins array will contain the lower bounds of the bin, for example if the first couple of cells are 20,21,22. You can use the FREQUENCY function to bin your data into whatever chunks you need to, with the syntax being =FREQUENCY(data_array, bins_array). I appreciate this is a very old thread, but for the benefit of others looking for a solution to this:

Histogram histogram excel