Thread
:
Creating an age or service spread chart
View Single Post
#
2
Posted to microsoft.public.excel.charting
Don Guillett
Posts: n/a
Creating an age or service spread chart
You could set up a separate table to get the info. List the departments and
use an indirect sumproduct formula such as
=SUMPRODUCT((ChecksB=B10)*1)
or
=SUMPRODUCT((ChecksB=B10)*ChecksD)
--
Don Guillett
SalesAid Software
"Dave Bradshaw" wrote in message
...
I have an XL2003 spreadsheet containing employee names, departments and
dates
of birth. I would like to set up charts showing (a) how many people are
in
each department and (b) how many people are of each age.
--
Dave B
Reply With Quote