Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Any way to build one stacked bar chart for three groups of dat
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I want chart source data to be relative references, not absolute. | Charts and Charting in Excel | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Why doesn't my chart update when underlying data changes? | Charts and Charting in Excel | |||
How do i add a line graph onto a stacked column chart using data | Charts and Charting in Excel | |||
Help making a chart that doesn't graph cells without data? | Excel Discussion (Misc queries) |