Nested Comumn Chart (help)
 

I have a column chart that has 7 cities on the X-axis and city revenue
on the vertical axis. each city has data for 5 different years. What
I want to do is divide the city revenue into it's two components and
have each column be divided into source 1 and source 2 contributions.
Can anybody help with this? Here is a jpeg of what I have. Like I
said I want each column to have a divider that shows the top part as
consisting of source one and the bottom part consisting of source 2.
http://www.geocities.com/monster_eco...enue_chart.JPG

Nested Comumn Chart (help)
 

Stacked-Clustered Column Charts:

http://peltiertech.com/Excel/ChartsH...sterStack.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Tim" wrote in message
ps.com...
I have a column chart that has 7 cities on the X-axis and city revenue
on the vertical axis. each city has data for 5 different years. What
I want to do is divide the city revenue into it's two components and
have each column be divided into source 1 and source 2 contributions.
Can anybody help with this? Here is a jpeg of what I have. Like I
said I want each column to have a divider that shows the top part as
consisting of source one and the bottom part consisting of source 2.
http://www.geocities.com/monster_eco...enue_chart.JPG