Histogram of Filtered Data

Arghhh! I just found this forum after viewing ExcelIsFun videos #31 and 37, and was about to post exactly the same question.

Here's hoping somebody has an answer.

Hi

See if this helps.

http://excelusergroup.org/forums/p/176/307.aspx
<input id="gwProxy" type="hidden"><!--Session data--><input *******="jsCall();" id="jsProxy" type="hidden">

Pivot table is a good idea. I will try it...

Also came up with my own solution. Add two things to the spreadsheet:
1. List of all valid filter items, and a validated cell where you can select the "current" item

2. New column in the data area with a simple formula that points to the original data column and multiplies it by a true/false item that depends on whether the row matches the "current" item. For my test case, the formula was: =B5*(A5=$E$1)
where:
B5 was the original data cell
A5 was a parameter of the row. In my case, it was the "load number" of the row, and I wanted to filter for a selected load number.
$E$1 was the value of the selected load number.

This formula returns zero for all rows that are not in the selected row number. Base the histogram on this new column, making sure that zero is outside the histogram range.