software

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?


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: www.excelforum.com/attachment.php?postid=4461 |
-------------------------------------------------------------------

--
Nicky------------------------------------------------------------------------
Nicky's Profile: www.excelforum.com/member.php...nfoamp;userid=312
View this thread: www.excelforum.com/showthread...hreadid=522225Thank you for the reply. I found my answer in Jon Peltier's page
peltiertech.com/Excel/ChartsH...sterStack.html

The link you provided came up as invalid but, thanks anyway!quot;Nickyquot; wrote:

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