I have a spreadsheet in Excel 2003 which contains the source data for a pie
chart on a separate sheet in the workbook showing number of different
categories that have occurred e.g. manual handling, transport , housekeeping
etc. These categories are counted using the formula
=COUNTIF(Sheet1!$F$2:$F$500,"Housekeeping") and the results are shown in a
table alongside the pie chart and used to generate the chart. The
spreadsheet contains data collected at intermittent times throughout the year
and the first column contains the date of that row's information. I would
like to be able to produce a monthly chart. How do I adjust the formula so it
only picks up data for each month. i have assumed that each month will have
its own chart in the workbook. the date can be formatted as required. At
the moment they go in as 1/1/09 for example but January could be used if
necessary
--
Josie