Histogram of select data
Posted by John H on March 06, 2001 3:14 PM
We measure 50 values each day and enter them into excel. Weekly I create histograms for the past 3 months for each. I want to set this up so others can click and go. I wrote a macro to speed up the histograms, but the input range is fixed. My problem is a way to select records out of my table for just the last 90 days.
The histogram function does not recognize the autofilter like a chart does, so the easy way was out. Instead, I indexed the data table and used a grid of VLOOKUP to pull the records over to the range referenced by the histogram macro. This works, but painfully slow. Any ideas?