histogram dynamic bin count

T

tpeter

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top