access pivot table chart with multiple Ranges shown

[superchew]

How do I build a pivot chart with multible ranges. for instance if I want to see widget sales from 9/1-9/28 as one group and 8/4-8/30 as another grouping?

[:) Sixthsense :)]

Use query with condition to populate the expected data and use it as the source of Pivot Chart