Countifs in Histogram with grouped data

mwf05

New Member
Joined
Jun 19, 2006
Messages
7
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.
 

Forum statistics

Threads
1,082,507
Messages
5,365,978
Members
400,863
Latest member
RobynP51

Some videos you may like

This Week's Hot Topics

Top