To plot a histogram in Excel, you need to go to the “Data” tab and then click on the “Data Analysis” box.
We will be working with monthly returns of two US stocks: Microsoft (MSFT) and Kellogg (K). Creating histograms with other statistical software Using Excel’s “data analysis” tool to plot a histogram.Interpreting histograms of stock returns.Moreover, we will explain how to interpret a histogram of stock returns. In this tutorial, we will show how to create a histogram using Excel. An easy way to visualize the distribution of stock returns is to plot a histogram.