View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Nicky
 
Posts: n/a
Default Any way to build one stacked bar chart for three groups of data?


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