+ Reply to Thread
Results 1 to 3 of 3

Bargraph with grouped and stacked bars?

  1. #1
    Registered User
    Join Date
    01-25-2010
    Location
    Joinville, Brazil
    MS-Off Ver
    Excel 2007
    Posts
    42

    Bargraph with grouped and stacked bars?

    Is it possible to make a bar graph like this:

    This is the data:

    jan09 feb09 mar09 .....
    Division 1
    Division 2
    Division 3
    Division 4
    Division 5

    jan08 feb08 mar08 .....
    Division 1
    Division 2
    Division 3
    Division 4
    Division 5


    The graph would be a bar graph with 2 bars next to each other per month. each bar would be stacked by division.

    The goal is to compare for example sales in 08 with sales in 09 showing 2 bars next to each other split by division.

    Thanks in advance.


    Edit: the version is 2007 excel
    Last edited by FortuneSyn; 01-27-2010 at 08:33 AM.

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Bargraph with grouped and stacked bars?

    Hi,

    I think you really mean columns, not bars, because you describe them as next to each other.

    check out this

    http://peltiertech.com/Excel/ChartsH...sterStack.html

  3. #3
    Registered User
    Join Date
    01-25-2010
    Location
    Joinville, Brazil
    MS-Off Ver
    Excel 2007
    Posts
    42

    Re: Bargraph with grouped and stacked bars?

    Perfect, thankyou very much!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1