What about a pivot chart?

"Steve P" wrote in message
...
Hi guys,

I recently bought Walkenbachs book on charting and got
some great tips and hints on how to improve the
presentation of my work.

I have a question though which I couldn't figure out from
the book.

Does somebody have an example of an interactive chart,
whereby you can choose the labels of x-axis of the chart ?
For example, in the same chart, I want to allow the user
to select monthly OR quarterly OR YTD sales information.
The labels of the x-axis will change accordingly (as will
the scale of the y-axis). In other words, the user "just"
has to select the time frame. I see some resemblance with
the chart "select series with checkboxes" of Chapter 7 of
Walkenbachs book, but in my case I want to select the time
frame (month, quarter, YTD) and not the data series as
such.

Lastly, I wasn't able to find an example of the chart
whereby quarterly info is shown vertically and monthly
info is shown horizontally ? (although Walkenbach shows an
example in the chart gallery i.e. chart 077). Where can I
find the workings of this chart in his book ?

Thanks guys

Steve P