Hi Pam, I'm not convinced I've understood what you want to get, but here's a possible solution (Maybe?) A B C D E F 1 PJ PR AB CD EF 2 Old 2 5 7 2 3 3 New 3 5 5 6 5 Then hilight A1:F3, INSERT>CHART, Choose COLUMN> STACKED COLUMN, then Finish. Is that what you wanted, or is it more complicated? <grin> Dave. -----Original Message----- From: Pamela Foreman [mailto:pamela.foreman@xxxxxxx] Sent: 31 January 2003 15:56 To: Mso Subject: [mso] Excel and charts Okay, here's a booger of a question. I hope someone can help me. I work at a university and our department is needing to show the number of students that were on our old degree plans and those on our new degree plans. This is how my boss wants it to look. She wants all this as a bar graph, all on the same bar graph. She wants those getting a print journalism degree on the old plan stacked on top of those getting the PJ degree with the new plan. Right next to it, she wants the old Broadcast people stacked on top of the new Broadcast people, the old PR people on top of the new, etc. We have 4-5 majors to do this with. I've got it drawn out how I want it. I've also tried putting the information into excel and making the chart, but nothing is working. Does anyone have a clue how I could set this up? Thanks! --Pam ============== Pamela Foreman Administrative Coordinator Journalism & Mass Communication Abilene Christian University ACU Box 27892 Abilene, TX 79601 (915) 674-2296 (915) 674-2139 (fax) pamela.foreman@xxxxxxx ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx?Subject=unsubscribe Or, visit the group's homepage and use the dropdown menu. This will also allow you to change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to use the files section for sharing files with the group, send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with instructions. Once you are a member of the files group, you can go here to upload/download files: http://www.smartgroups.com/vault/msofiles ************************************************************* ************************************************************* You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or MicrosoftOffice@xxxxxxxxxxxxxxxx To send mail to the group, simply address it to mso@xxxxxxxxxxxxx To Unsubscribe from this group, send an email to mso-request@xxxxxxxxxxxxx?Subject=unsubscribe Or, visit the group's homepage and use the dropdown menu. This will also allow you to change your email settings to digest or vacation (no mail). //www.freelists.org/webpage/mso To be able to use the files section for sharing files with the group, send a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with instructions. Once you are a member of the files group, you can go here to upload/download files: http://www.smartgroups.com/vault/msofiles *************************************************************