I have a data set of values that is grouped into 6 buckets (Tier). I am using Countifs to generate a histogram of the values for each bucket (=COUNTIFS(MinCoverage!$H:$H,">"&$A7,MinCoverage!H:H,"<"&$A8,MinCoverage!$E:$E,Tier)). The histogram works great for each bucket/Tier. However, I also want to be able to generate a histogram that would include all buckets. This can somewhat be done through PivotTable and Chart but it excludes bins that have no value. So I would like to be able to change Tier to a value of from 1 to 6 and get those histograms and then a wildcard (* doesn't work) to get a histogram for all the buckets.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Countifs in Histogram with grouped data
Similar threads
- Question
