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, Mar 4, 2008
    1. Advertisements

  2. rsenn

    Del Cotter Guest

    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

    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, Mar 4, 2008
    1. Advertisements

  3. rsenn

    Jon Peltier Guest

    Jon Peltier, Mar 5, 2008
  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?

    Luba, Mar 27, 2013
    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.