(these are irrelevant so are excluded here)Īpplication.Run 'ATPVBAEN.XLAM!Histogram', pasteRange, ActiveSheet.Range('$AK$23'), pasteRange2, False, False, True, FalseĪctiveSheet.Shapes('Chart 1').IncrementLeft -31.2ĪctiveSheet.Shapes('Chart 1').IncrementTop -1.2ĪctiveSheet.ChartObjects('Chart 1').ActivateĪctiveSheet.Shapes('Chart 1').ScaleWidth 1. The code I tried so far is: Dim I As Integer Follow the steps below to adjust the bin size: Right click on the bin data series and select Format Data Series.

Now, Excel will plot a histogram based on your highlighted data. Picture 2- how to create a histogram chart in Excel 2016. I am not a CS major and new to VBA - sorry if this question is silly and thank you very much for your help! Excel will automatically create bins from the data. Click on Insert Statistical Charts from the Charts section. Only one chart has been created among the worksheets, and there is no data in it (the chart code is copied from running a macro). If I keep pressing OK VBA would crash, and if I press Cancel, only the last worksheet generates the table. The code I have so far does not generate the table and whenever I run it a window pops up and asks me to press OK to overwrite data. The table should be located at cell AK23 and the graph should be spanning N2:S20 in each worksheet.

(2) the Bin Range (the interval I want to use for the analysis), represented by 'pasteRange2' in my code.Ĭreate both the histogram table and histogram graph. (1) the Input Range (the data I want to analyze), represented by 'pasteRange'in my code. Click on the histogram icon in the center of the Insert ribbon. Just follow these steps: Select your data. In each worksheet, I have these two columns of values: Start for Free Method 1: Use the built-in histogram chart type Since Excel 2016, there is a built-in chart type called histogram. Hi I am trying to create a histogram for each worksheet in a workbook.

Create histogram excel