If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Charts
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 |
#2
|
|||
|
|||
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" wrote in message ... 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
|
|||
|
|||
Charts
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? -- mariab ------------------------------------------------------------------------ mariab's Profile: http://www.excelforum.com/member.php...o&userid=31118 View this thread: http://www.excelforum.com/showthread...hreadid=507850 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel Charts Linked to Spreadsheets | Rich | Charts and Charting | 1 | July 4th, 2005 04:36 PM |
How to Make Pie Charts the Same Size | Jon Peltier | Charts and Charting | 0 | May 3rd, 2004 09:34 PM |
Distribute dynamically charts with linked data as stand-alone charts | Richard | Charts and Charting | 2 | March 31st, 2004 05:16 PM |
charts inadvertly resized | Hammer_757 | Charts and Charting | 0 | March 24th, 2004 02:16 AM |
Creating a large number of charts automatically (repost) | Francine Kubaka | Charts and Charting | 0 | September 21st, 2003 09:16 PM |