A pivot table can group a row variable - so if your raw data are dates, you
can group at week, month, I believe quarter, and year.

--
Regards,
Tom Ogilvy

"Steve P" wrote in message
...
mmm, haven't thought about that, would that do the trick
in the most efficient manner ? Would this give me the
option to change time frames (month, quarter, YTD)in the
same chart ? I was more thinking of doing something in
VBA...

Thanks for your comment anyway.
Steve P


-----Original Message-----
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




.