Click on “PivotChart” in the “Charts” section of the “Insert” ribbon.Follow these steps (the numbers relate to the pictures). You insert a PivotChart and use the function to group the data. The second method also works with Excel versions before 2016. Now you can proceed defining the layout, e.g. Number 6 on the screenshots shows the result, if you set the bin width to “1.0”, the overflow bin to “6.0” and the underflow bin to “2.0”. Excel then summarizes all items below the underflow bin into one column on your chart.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |