Figure 3: Layout in Excel for Creating a Dynamic Scaled Histogram. Creating a Scaled Histogram If you want to compare your histogram with a probability distribution, you will need to scale the histogram so that