Stacked bar chart, Excel 2007

Discussion in 'Excel Charting' started by rsenn, Mar 4, 2008.

  1. rsenn

    rsenn Guest

    I have 5 columns.

    Column A is 1 through 12 for months.

    Column B is Dept 1 Budget for each month.
    Column C is Dept 2 Budget for each month.

    Column D is Dept 1 Actual for each month.
    Column E is Dept 2 Actual for each month.

    I'm trying to create two stacked bars per month, one of Columns B&C (Budget)
    and one of Columns D&E (Actual).

    The best I can get is one column per month with all 4 values stacked.

    How can I turn this into two columns per month?



    --
    rsenn
     
    rsenn, Mar 4, 2008
    #1
    1. Advertisements

  2. rsenn

    Del Cotter Guest

    On Tue, 4 Mar 2008, in microsoft.public.excel.charting,
    rsenn <> said:
    >I'm trying to create two stacked bars per month, one of Columns B&C (Budget)
    >and one of Columns D&E (Actual).
    >
    >The best I can get is one column per month with all 4 values stacked.
    >
    >How can I turn this into two columns per month?


    Keep the columns just the way they are, but instead of one row per
    record, have three. First row is Budget, second is Actual, and third is
    blank.

    Format the stacked columns to have zero space between columns, and let
    the blank row serve as a space instead. Now your stacked columns will
    look like pairs of columns.

    --
    Del Cotter
    NB Personal replies to this post will send email to ,
    which goes to a spam folder-- please send your email to del3 instead.
     
    Del Cotter, Mar 4, 2008
    #2
    1. Advertisements

  3. rsenn

    Jon Peltier Guest

    Here are links to a few illustrated examples:

    http://peltiertech.com/Excel/ChartsHowTo/ClusterStack.html

    - Jon
    -------
    Jon Peltier, Microsoft Excel MVP
    Tutorials and Custom Solutions
    Peltier Technical Services, Inc. - http://PeltierTech.com
    _______


    "Del Cotter" <> wrote in message
    news:1qeg$...
    > On Tue, 4 Mar 2008, in microsoft.public.excel.charting,
    > rsenn <> said:
    >>I'm trying to create two stacked bars per month, one of Columns B&C
    >>(Budget)
    >>and one of Columns D&E (Actual).
    >>
    >>The best I can get is one column per month with all 4 values stacked.
    >>
    >>How can I turn this into two columns per month?

    >
    > Keep the columns just the way they are, but instead of one row per record,
    > have three. First row is Budget, second is Actual, and third is blank.
    >
    > Format the stacked columns to have zero space between columns, and let the
    > blank row serve as a space instead. Now your stacked columns will look
    > like pairs of columns.
    >
    > --
    > Del Cotter
    > NB Personal replies to this post will send email to
    > ,
    > which goes to a spam folder-- please send your email to del3 instead.
     
    Jon Peltier, Mar 5, 2008
    #3
  4. rsenn

    Luba Guest

    Hi Jon,

    Thanks so much for this.

    One question -- How do you reduce the gap between the bars/charts for the "clustered" look?

    Thanks!
    Luba

    On Tuesday, March 4, 2008 1:18:02 PM UTC-8, rsenn wrote:
    > I have 5 columns.
    >
    > Column A is 1 through 12 for months.
    >
    > Column B is Dept 1 Budget for each month.
    > Column C is Dept 2 Budget for each month.
    >
    > Column D is Dept 1 Actual for each month.
    > Column E is Dept 2 Actual for each month.
    >
    > I'm trying to create two stacked bars per month, one of Columns B&C (Budget)
    > and one of Columns D&E (Actual).
    >
    > The best I can get is one column per month with all 4 values stacked.
    >
    > How can I turn this into two columns per month?
    >
    >
    >
    > --
    > rsenn
     
    Luba, Mar 27, 2013
    #4
    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. Jon Peltier
    Replies:
    2
    Views:
    273
    Jon Peltier
    Jan 22, 2005
  2. Jacqueline
    Replies:
    1
    Views:
    240
    Debra Dalgleish
    Feb 17, 2005
  3. y
    Replies:
    3
    Views:
    225
    Jon Peltier
    Mar 17, 2008
  4. Sin
    Replies:
    8
    Views:
    245
  5. Marshall
    Replies:
    3
    Views:
    268
    Jon Peltier
    Jun 19, 2007
  6. Confused One
    Replies:
    1
    Views:
    198
    Andy Pope
    Aug 14, 2008
  7. Robyda
    Replies:
    4
    Views:
    313
    Jon Peltier
    Aug 24, 2008
  8. Leon
    Replies:
    7
    Views:
    263
    Jon Peltier
    May 15, 2009
Loading...