Combination Column and Stacked Column Chart in XL 2007
 

I would like to create a bar chart with International and Domestic sales data
plotted against a total sales plan for Q1, Q2, Q3 and Q4 2008. I want the
International and Domestic data to appear as a stacked colum with the planned
sales data as a single bar next to the stacked column data. How do I do this?

Data appears as follows:

Total Bookings Domestic Bookings International Bookings Plan
Q1 1 5
4
Q2 2 4
4

Combination Column and Stacked Column Chart in XL 2007
 

Here are some links that should help:

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

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


"Pat R." <Pat wrote in message
...
I would like to create a bar chart with International and Domestic sales
data
plotted against a total sales plan for Q1, Q2, Q3 and Q4 2008. I want the
International and Domestic data to appear as a stacked colum with the
planned
sales data as a single bar next to the stacked column data. How do I do
this?

Data appears as follows:

Total Bookings Domestic Bookings International Bookings Plan
Q1 1 5
4
Q2 2 4
4