Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
histogram dynamic bin count
I have data that is filtered using the advanced filter and the subtotal
funtion( to get std dev, average, and count) the charts change based on the filtered data. I would now like to make a histogram that changes as the filter changes. This would be in quarter percent increments from -10 to 10 bin sizes. The subtotal function works but there is no criteria for the count. Is there a way to change the bin count to reflect only visible data? DCount looks like it would work but it is not available in the subtotal options. Thank you for your help. Tim Peter |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Count() in Dynamic Formula | Excel Discussion (Misc queries) | |||
Count dynamic range | Excel Worksheet Functions | |||
I was creating a histogram; now i have data but no histogram. | Excel Worksheet Functions | |||
How to Histogram w/o raw data but histogram Table on Excel | Charts and Charting in Excel | |||
I would like to count # of occurences but have it be dynamic when. | Excel Worksheet Functions |