Stacked and Column Chart

[Elaine]

Hello,

Using the data below I would like to create a single chart with a Column
Stacked Chart for Revenues and a Column for Expenditures. Can u help me?

Revenues FY03 FY04 FY05
Private/Local Govt. $1,500,928.00 $2,598,394.00 $7,030,199.00
State $821,388.00 $3,467,473.00 $20,413,581.00
Ship Funding $15,806,578.00 $19,233,564.00 $23,902,364.00
Flowthru (Federal) $10,036,098.00 $10,595,406.00 $13,369,788.00
Federal Government $68,276,270.00 $1,604,082.00 $63,199,215.00

Expenditures $132,1452,481.00 $128,672,032.00 $125,672,032.00

 

[Del Cotter]

Using the data below I would like to create a single chart with a Column
Stacked Chart for Revenues and a Column for Expenditures. Can u help me?

Revenues FY03 FY04 FY05
Private/Local Govt. $1,500,928.00 $2,598,394.00 $7,030,199.00
State $821,388.00 $3,467,473.00 $20,413,581.00
Ship Funding $15,806,578.00 $19,233,564.00 $23,902,364.00
Flowthru (Federal) $10,036,098.00 $10,595,406.00 $13,369,788.00
Federal Government $68,276,270.00 $1,604,082.00 $63,199,215.00
Expenditures $132,1452,481.00 $128,672,032.00 $125,672,032.00

You want a "clustered stacked column chart", of which you can find
examples by googling this expression

www.google.com/search?q=clustered+stacked+column+chart

The first hit takes you to Jon Peltier's site:

peltiertech.com/Excel/ChartsHowTo/ClusterStack.html

He points to worked examples by Bernard Liengme and Andy Pope

www.stfx.ca/people/bliengme/ExcelTips/Columns.htm.

andypope.info/charts/stackside.htm

The key mental trick is to pretend that the "unstacked" columns are
really stacked, but that they just happen to only have one populated
row, and the stacked columns "contain" a row for expenditure, but it
happens to be empty. Arrange your data like this:

FY03 FY04 FY05
Rev Exp Rev Exp Rev Exp
Private 1,501 2,598 7,030
State 821 3,467 20,414
Ship 15,807 19,234 23,902
Flowthru 10,036 10,595 13,370
Federal 68,276 1,604 63,199
Total 132,145 128,672 125,672

Set the gap between columns in the chart to zero, and create "gaps"
between the clusters by having empty spreadsheet columns.

 

[Elaine]

I'll check it out and thank you for your quick response to my question. I'm
so glad to have access to great MVP's like yourself. It is truly appreciated.

 

[Del Cotter]

I'll check it out and thank you for your quick response to my question. I'm
so glad to have access to great MVP's like yourself. It is truly appreciated.

Thank you. However, Jon, Bernard and Andy are MVPs; I'm just a fellow
Excel user.