how do i build a stacked bar graph with three variables?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

claryal - 12 Oct 2007 22:08 GMT

want to construct a stacked bar graph with each bar representing a specific
variable and the components of it.

Reply to this Message

John Mansfield - 13 Oct 2007 03:22 GMT

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.

Signature

John Mansfield
http://cellmatrix.net

> want to construct a stacked bar graph with each bar representing a specific
> variable and the components of it.

Reply to this Message

claryal - 15 Oct 2007 13:31 GMT

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.

> 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
[quoted text clipped - 14 lines]
> > want to construct a stacked bar graph with each bar representing a specific
> > variable and the components of it.

Reply to this Message