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
     
    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, Nov 5, 2009
    #2
    1. Advertisements

  3. CB

    Guest

    Jon,

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

Ask a Question

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

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.