One simple way is to have a further column with a formula of

=IF(AND($D$1="x",MOD(MONTH(A1),3)<0),NA(),B1)

and then just chart columns A & C. Normally you get each month, put x in D1,
and only the quarters show.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Gaurav Aidasani" <Gaurav wrote in
message ...
I have a set of data, the number of aircrafts sold each month from 1992
till
2007. I want to display them onto a column chart (easy!) but occassionally
I
want it to show only the data for each quarter, and not all of them. Whats
the simplest and easiest way of doing that without having to put in
quarter
columns and selecting to plot those?

thanks