If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Creating an age or service spread chart
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 |
#2
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Creating a High-Low-Close chart with multiple series? | The Chad | Charts and Charting | 3 | June 7th, 2007 06:32 PM |
Creating a line chart with two X-axes!! | JaVaughn | General Discussion | 1 | June 30th, 2005 01:36 PM |
Urgent Chart Questions | Brent E | General Discussion | 0 | May 9th, 2005 11:01 PM |
Creating a time chart | Don Rountree | Charts and Charting | 1 | February 13th, 2004 03:11 PM |
Styles for chart | Debra Dalgleish | Charts and Charting | 1 | October 3rd, 2003 12:27 PM |