We would like to create a chart that displays the invoices based on their aging status, grouped into equal intervals, 1-30, 31-60, 61-90 days, and so on. We have exported a list of open invoices from our accounting system. In this post, we’ll create a histogram using a PivotChart. For example, the number of days with a high temperature between 71-80 degrees, 81-90, and 91-100, the number of students with test scores between 60-69, 70-79, 80-89, or the number of invoices that are due in 31-60, 61-90, or 91-120 days. A histogram graphically displays the number of items that fall within equal intervals, or, bins.
