charting filtered date using arrays

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.
 
T

Tushar Mehta

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating multiple charts from large data file 0
Excel 2007 limitations when plotting variable width column charts 1
create chart from one table 0
Pivot Tables/Charts and common filter 1
bar chart with dates on the x-axis 4
Getting the state of a chart. 0
Pivot Chart Grouping 0
How to dynamically set the lower and upper limits of the axes on a MSAccess xy-chart. 0

Top