dynamic charts

The Fibonacci Clock is getting quite some attention on the web lately. Check it out here and read about how it works. Short summary: The clock consists of five squares with different magnitudes: 5 – 3 – 2 – 1 and 1 again. Add up the magnitudes for the red and the blue squares to arrive [...]

Here is an example of a dynamic chart that changes based on the selected cell. Move up or down to see more data points for a category, move sideways to switch between categories. Done with a SelectionChange macro and dynamic ranges. Read how it’s done… cheers, teylyn