how do i build a stacked bar graph with three variables? in Excel Charts    |   |  Help   Search For:     In:   Office   Excel     Excel General Questions     Excel New users     Excel Application Errors     Excel Charts     Excel Programming     Excel Setup     Excel Worksheet Functions              claryal 10/12/2007 2:07 PM PST   Question   want to construct a stacked bar graph with each bar representing a specific variable and the components of it.     Was this post helpful to you?         Reply |   Top           John Mansfield 10/12/2007 7:21 PM PST   Answer   Assume that the data set below resides in the range A1:C4. Groups A, B, and C are the three variables. Each group has three components which consist of the numbers under each group. Group A Group B Group C 1 2 3 4 3 2 6 5 5 Select the range A1:C4. Click on the Chart Wizard. In step 1 of the chart wizard, choose the stacked column chart. Hit the next button. In step two of the chart wizard select the series in rows. Hit the next button. In step three add titles, etc. Hit the next button. In step 4 of the wizard choose the chart location. Finally, hit the Finish button and the chart should be complete. -- John Mansfield http://cellmatrix.net "claryal" wrote: > want to construct a stacked bar graph with each bar representing a specific > variable and the components of it.     Was this post helpful to you?         Reply |   Top           claryal 10/15/2007 5:30 AM PST   Excellent idea; however, my particular problem was better solved using a pivot table chart. A local person helped me build it. thanks for your input. "John Mansfield" wrote: > Assume that the data set below resides in the range A1:C4. Groups A, B, and > C are the three variables. Each group has three components which consist of > the numbers under each group. > > Group A Group B Group C > 1 2 3 > 4 3 2 > 6 5 5 > > > Select the range A1:C4. Click on the Chart Wizard. In step 1 of the chart > wizard, choose the stacked column chart. Hit the next button. In step two > of the chart wizard select the series in rows. Hit the next button. In step > three add titles, etc. Hit the next button. In step 4 of the wizard choose > the chart location. Finally, hit the Finish button and the chart should be > complete. > > -- > John Mansfield > http://cellmatrix.net > > > > > > "claryal" wrote: > > > want to construct a stacked bar graph with each bar representing a specific > > variable and the components of it.     Was this post helpful to you?         Reply |   Top         Return to Microsoft Communities   Notify me of replies