Can you embed a stacked column chart within a stacked column?

[sroche]

I am attempting to embed a stacked column chart within a stacked column.

Essentially I have a set of data (revenue) that is categorized by high, medium and low. Within each respective category there are several projects that make up the groupings. I would like to graph the revenue forecast by month (X-axis Time, Y-Axis $Rev), and within each month categorize the target revenue by H-M-L probability, however within those probability groups I want to be able to illustrate the individual projects (customers) that make up each probability group....

Doable? Help!?

-Steve

 

[pgc01]

Hi Steve
Welcome to the board

Jon Peltier explains here how to create a Clustered and Stacked Column chart:

http://peltiertech.com/WordPress/clustered-stacked-column-bar-charts/

 

[sroche]

That isn't quite it...

For example:

In Jan I am forecasting 20M in Revenue.

Of the 20M, 4M is categorized high prob, 13M med prob, and 3M low prob. (First level of clasification- probability)

Of the 4M High: 2M is Customer A, 2M is Customer B
Of the 13M Med: 10M is Customer C, 3M is Customer D
Of the 3M Low: 1M is Customer E, 2M is Cusomer F
(Second level of classification, Customer within each prob group)

I want to represent this is in a clustered column chart- first grouping the revenues by probability by month, then within the probability classification what specific customer contracts.

Thank you

-Steve