Single Series Stacked Column - HELP

Discussion in 'Excel Charting' started by CB, Nov 4, 2009.

  1. CB

    CB Guest

    I am working late and frustrated. I need to construct a single series
    vertical stacked column to show a fundraising results for a special challenge
    with giving to 5 programs on our school website. I have tried for hours in
    excel 2007, searched online for templates. One answer said you can do it in
    2003 with the template wizard, then save it in 2007. I don't have 2003.

    Here is my ss:

    Fund 1 Fund 2 Fund 3 Fund 4 Fund 5 Total
    11,000 8,000 200 11,000 5,000 35,200
    --
    Frustrated in SC
     
    CB, Nov 4, 2009
    #1
    1. Advertisements

  2. CB

    Jon Peltier Guest

    Single series means only one item in the stack. I think what you want is
    a single stack with five series (for the five funds).

    Select the data (not including the Total column), create a stacked
    column chart, then change rows and columns so the series are in columns.

    - Jon
    -------
    Jon Peltier
    Peltier Technical Services, Inc.
    http://peltiertech.com/



    CB wrote:
    > I am working late and frustrated. I need to construct a single series
    > vertical stacked column to show a fundraising results for a special challenge
    > with giving to 5 programs on our school website. I have tried for hours in
    > excel 2007, searched online for templates. One answer said you can do it in
    > 2003 with the template wizard, then save it in 2007. I don't have 2003.
    >
    > Here is my ss:
    >
    > Fund 1 Fund 2 Fund 3 Fund 4 Fund 5 Total
    > 11,000 8,000 200 11,000 5,000 35,200
     
    Jon Peltier, Nov 5, 2009
    #2
    1. Advertisements

  3. CB

    Guest

    Jon,

    That worked great! Thanks.
     
    , Dec 30, 2013
    #3
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. jcknortheast
    Replies:
    1
    Views:
    274
    Stephen Bullen
    Dec 5, 2003
  2. Pablo

    stacked column and non-stacked single line

    Pablo, Feb 24, 2004, in forum: Excel Charting
    Replies:
    2
    Views:
    279
    auee99
    Oct 29, 2004
  3. nlee144(NoSpamTakeSquareRootOfNumber)

    Multiple Series of Series in Stacked Column chart?

    nlee144(NoSpamTakeSquareRootOfNumber), Jun 4, 2004, in forum: Excel Charting
    Replies:
    2
    Views:
    259
    Jon Peltier
    Jun 5, 2004
  4. Julie

    Stacked Column on single column

    Julie, Aug 20, 2004, in forum: Excel Charting
    Replies:
    2
    Views:
    108
    Julie
    Aug 21, 2004
  5. Jacqueline
    Replies:
    1
    Views:
    237
    Debra Dalgleish
    Feb 17, 2005
  6. Charlotte C
    Replies:
    1
    Views:
    103
    Tushar Mehta
    Dec 3, 2005
  7. Donald Macleod
    Replies:
    2
    Views:
    229
    Jon Peltier
    Jan 30, 2006
  8. Robyda
    Replies:
    4
    Views:
    306
    Jon Peltier
    Aug 24, 2008
Loading...