View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
waldetta waldetta is offline
external usenet poster
 
Posts: 5
Default Am confused about a simple data layout- need help asap!

This is really silly, because I am good at charts, but for some reason, I
cannot formulate in my head the proper layout of this chart. Here is what I
have/need:

THESE ARE MY DATA HEADERS:

A B C D E
F

PERSON JOB 1 JOB 2 JOB 3 TOTAL ARBITRARY
1-3
NUMBER
THE DATA LOOKS LIKE THIS:

A B C D E F
NAME1 3 2 8 13 2
NAME2 4 6 2 12 7
NAME3 1 9 0 10 3
NAME4 0 7 4 11 6

I want to see the relationship between B to F, C to F, and D to F. Column E
may not be used at all.