Running Calculations to build chart
 

I have the following columns: Job Title, Week, Total People

The data looks like this:

Job Title Week Total People
PM W2 1
Tech Edit W3 5
Net Engineer W2 2
Programmer W12 10
Programmer2 W1 5
.....

I have a named range of weeks, W1, W2, W3, W4, W5, W6, W6, W8, W8,
W10, W11, W12, named "weeks".

I'm trying to build a chart to show the total number of people for
each week. So I need to total up all the W1s, W2s, etc. to display my
chart.

Running Calculations to build chart
 

Hi - I am using Excel 200.
Select your Data
Job Title Week Total People
PM W2 1
Tech Edit W3 5
Net Engineer W2 2
Programmer W12 10
Programmer2 W1 5
....


From Menu--Data--Pivot Table.

Drag Week to far left and Total People to Right.

field settings -- "Sum of Total People"

make chart from Pivot Table.

HTH


"cs_in_va" wrote in message
...
I have the following columns: Job Title, Week, Total People

The data looks like this:

Job Title Week Total People
PM W2 1
Tech Edit W3 5
Net Engineer W2 2
Programmer W12 10
Programmer2 W1 5
....

I have a named range of weeks, W1, W2, W3, W4, W5, W6, W6, W8, W8,
W10, W11, W12, named "weeks".

I'm trying to build a chart to show the total number of people for
each week. So I need to total up all the W1s, W2s, etc. to display my
chart.

Running Calculations to build chart
 

Check your other post, too.

cs_in_va wrote:

I have the following columns: Job Title, Week, Total People

The data looks like this:

Job Title Week Total People
PM W2 1
Tech Edit W3 5
Net Engineer W2 2
Programmer W12 10
Programmer2 W1 5
....

I have a named range of weeks, W1, W2, W3, W4, W5, W6, W6, W8, W8,
W10, W11, W12, named "weeks".

I'm trying to build a chart to show the total number of people for
each week. So I need to total up all the W1s, W2s, etc. to display my
chart.

--

Dave Peterson