Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    Jan 2001
    Location
    Minneapolis, MN
    Posts
    38
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Stacked Column Chart? (Excel 2000 - SR1)

    I have data that looks like so:

    <pre>Type Sub-Type Count
    A red 3
    A orange 8
    A yellow 10
    A blue 4
    A green 1
    B apples 2
    B oranges 4
    B grapes 9
    B pineapple 7
    B pears 12
    </pre>


    I'd like to make this a stacked column graph with the Sub-Types being shown in a legend. Can it be done? If so, how? The Stacked Column graphing help is ... not good, and my reference work (from QUE) is no help either.

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Stacked Column Chart? (Excel 2000 - SR1)

    Best is to change the layout of your data slightly so the fruit is in a different column from the colours:
    <pre>Sub-Type Count
    red 3
    orange 8
    yellow 10
    blue 4
    green 1
    apples 2
    oranges 4
    grapes 9
    pineapple 7
    pears 12
    </pre>


    Then select all three columns and all rows and base you chart on that data, make sure you select the data is in rows, rather that in columns when you choose a stacked chart type.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •