Thread: Any way to build one stacked bar chart for three groups of data?

I have three groups of data made of several cells of data each and would like
to represent them on one chart. I would like to have each group represented
as a separate stacked column so I can see the individual columns for each
cell within the group and still see the relationship of the groups to each
other. Is this possible?

Thank you for the reply. I found my answer in Jon Peltier's page
http://peltiertech.com/Excel/ChartsH...sterStack.html

The link you provided came up as invalid but, thanks anyway!


"Nicky" wrote:

>
> yes. Try using two columns (or rows) not one for you axis labels. This
> allows you to have separate columns for sub-groups under each broad
> axis label.
>
> eg in the attached example, having the names of months as the major
> axis label and the names of staff as the secondary label, you can show
> the components of staff pay in side-by-side columns each month.
>
>
> +-------------------------------------------------------------------+
> |Filename: eg.jpg |
> |Download: http://www.excelforum.com/attachment.php?postid=4461 |
> +-------------------------------------------------------------------+
>
> --
> Nicky
>
>
> ------------------------------------------------------------------------
> Nicky's Profile: http://www.excelforum.com/member.php...nfo&userid=312
> View this thread: http://www.excelforum.com/showthread...hreadid=522225
>
>