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.
