![]() It will instantly change the data summary as well as the chart. Right click in Row area, choose Group … and change the BY value from 10 to anything else. It offers many other things which the data analysis add-in is simply not capable of. ![]() And we now have a Histogram!īoth look the same. Reduce the gap width to zero and add a border. This is the frequency distribution across bins. Right click in the data area and choose Summarize Values By – choose Count (because we are counting how many fell in each bin). Now it shows bins separated by 10 and their sums. Right click in the row area and choose Group … and choose Group By value as 10. Not very useful right now because there are too many rows. It will show all unique quantities and their totals. Put Qty Sold column in Row area as well as Data area. But the method of creating the histogram is different. The data is exactly the same as the previous article. In this article, we will see another way of creating Histogram using Pivot Table.ĭownload this sample file and follow along. This is continuation of the previous article.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |