charting filtered date using arrays

  • Thread starter Thread starter Winshent
  • Start date Start date
W

Winshent

i want to be able to set the data source within a chart to filter data
from a complete recordset and then chart it. Each chart would filter
on an ID within the data.

With generating tables i use arrays such as:

=(SUM((Date="Tuesday")*(Line="ITSupport")*(Area=London)*(NumberofCalls)))

can i do something similar with the data series in a chart, as i need
a seperate chart for each organisation id that is being reported on.

the data will be deleted and requeried and imported on a reg basis
hence the need for filtering.
 
Take a look at PivotTable and PivotChart. With the 'organization id'
as a row (or even a page) field, you should be able to get what you
want.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Back
Top