Software

Ask something
Discussion Locked

Automatically update histogram in Excel

0 helpful
3 replies

by el machete

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Here is my dylema:

I have a spreadsheet where I collect data using ODBC. I then create some trends using charting and finally I use the histogram utility to create some histograms. My problem is that when I refresh the data in Excel the trends get updated but the histograms don't. I am looking for a way to either refresh the histograms automatically or by running a macro to refresh them.

3 replies

by dklippert

The histogram tool has no automatic update capability.

Try the FREQUENCY function, with a chart based on the result of the function.
Or record a macro that reconstructs the histogram.

by el machete

After several days of research and playing around with Excel Macros and VBA I found the perfect solution.
If you are interested in finding out how I did it please let me know.

This discussion is closed to new replies.