Excel Charts need to have a funtion where you can Stack and Group
 

The chart function does not allow to have both stacking and group of data.
For example, we want to have 5 Scenarios, each with a !2month Impact, 24month
IMpact and a 36month impact, and then have each of these impacts be broken
out between Direct and Indirect.

Therefore, the Direct & Indirect portions would be stacked upon each other
for each time period. then the columns for the 3 time periods would be placed
directly next to each other in a group by scenario. THe Scenarios would then
all lie next to each other, with a bit of space to show they are different
scenarios

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...excel.charting

Hi Denise,

The chart function does not allow to have both stacking and group of data.

This effect can be achieved by careful arrangement of the source data. See
the FunChrt4.zip file on my web site (www.oaltd.co.uk/Excel) for an example.

Regards

Stephen Bullen
Microsoft MVP - Excel

Professional Excel Development
The most advanced Excel VBA book available
www.oaltd.co.uk/ProExcelDev