+ Reply to Thread
Results 1 to 3 of 3

Charts

  1. #1
    Registered User
    Join Date
    02-02-2006
    Posts
    6

    Combining Charts

    I know how to produce group and stacked bar graphs, but I do not know how to combine the two designs into one graph.

    For example, Item A and B on the x axis each have 4 bars grouped together. Now, I'd like to have additional information stacked withing each of these 4 bars.

    Any insight would be greatly appreciated!
    Last edited by mariab; 02-02-2006 at 04:18 PM.

  2. #2
    Jon Peltier
    Guest

    Re: Charts

    Here are some links that show how to do this:

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

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


    "mariab" <[email protected]> wrote in
    message news:[email protected]...
    >
    > I know how to produce group and a stacked bar graphs, but I do not know
    > how to combine the two designs into one graph.
    >
    > For example, Item A and B on the x axis each have 4 bars grouped
    > together. Now, I'd like to have additional information stacked withing
    > each of these 4 bars.
    >
    > Any insight would be greatly appreciated!
    >
    >
    > --
    > mariab
    > ------------------------------------------------------------------------
    > mariab's Profile:
    > http://www.excelforum.com/member.php...o&userid=31118
    > View this thread: http://www.excelforum.com/showthread...hreadid=507850
    >




  3. #3
    Registered User
    Join Date
    02-02-2006
    Posts
    6

    Thank You

    Thank you very much for the link! The directions helped me set up this type of graph. I am now having a different problem. I confirmed that I highlighted the correct areas but all of the information is not being displayed within some of the stacked bars. I have 4 stacked bars for one x value and one of them is only showing 10 out of the 16 that is should stack. Any insight?

+ 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