Pseudocharts and Window Charts

The next example is completely different from the blood-pressure chart. It is a simplified variant of a real-life example. In this case, we also had a "long sequence"; that is, a value chain with even 96 values of eight consecutive years. This data collection was not essential as a whole in this case, but to provide an excerpt of any 12 months. The data pane should always be a freely definable eighth of the entire period. In addition, a specific user requirement had to be fulfilled: the user wanted to freely decide via simple mouse activities—also back and forth—which calendar month of which calendar year would be the first month of the currently displayed 12-month period.

These requirements were fulfilled with a ...

Get Create Dynamic Charts in Microsoft® Office Excel® 2007 and Beyond now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.