J
JohnWRS
Does anyone know how to create a histogram that remains dynamicall
linked to the source data?
I can use the histogram plug-in, but when I "down select" the sourc
data using Autofilter, the histogram does not update. I've figured ou
that the histogram macro must be re-run on the new data. Also, hidin
rows in the source data (as in Autofilter) does not exclude those row
from the computations of the histogram macro. When I select a reduce
set of records, the Histogram Macro reads all the source rows, eve
those that are hidden.
I was able to create a frequency distribution chart by using an arra
function; FREQUENCY, and it dynamically updates actual changes in th
source data range, but it also will not exclude the rows hidden b
Autofilter.
I really need the SQL query capabilities of Access and the char
capabilities of Excel. Appreciate any thoughts you might have. Bes
regards, Joh
linked to the source data?
I can use the histogram plug-in, but when I "down select" the sourc
data using Autofilter, the histogram does not update. I've figured ou
that the histogram macro must be re-run on the new data. Also, hidin
rows in the source data (as in Autofilter) does not exclude those row
from the computations of the histogram macro. When I select a reduce
set of records, the Histogram Macro reads all the source rows, eve
those that are hidden.
I was able to create a frequency distribution chart by using an arra
function; FREQUENCY, and it dynamically updates actual changes in th
source data range, but it also will not exclude the rows hidden b
Autofilter.
I really need the SQL query capabilities of Access and the char
capabilities of Excel. Appreciate any thoughts you might have. Bes
regards, Joh