Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Stacked and Column Chart
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 -- Thank you... Elaine |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Stacked and Column Chart
Elaine said:
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 http://www.google.com/search?q=clust...d+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 http://www.stfx.ca/people/bliengme/E...ps/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. -- Del Cotter NB Personal replies to this post will send email to , which goes to a spam folder-- please send your email to del3 instead. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Stacked and Column Chart
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. -- Elaine "Del Cotter" wrote: Elaine said: 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 http://www.google.com/search?q=clust...d+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 http://www.stfx.ca/people/bliengme/E...ps/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. -- Del Cotter NB Personal replies to this post will send email to , which goes to a spam folder-- please send your email to del3 instead. |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Stacked and Column Chart
On Wed, 31 Oct 2007, in microsoft.public.excel.charting,
Elaine said: 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. -- Del Cotter NB Personal replies to this post will send email to , which goes to a spam folder-- please send your email to del3 instead. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stacked column chart wit more than one column in a data point | Charts and Charting in Excel | |||
Needed: Chart that combines clustered column and stacked column types | Charts and Charting in Excel | |||
How to combine stacked column with a cluster column chart? | Charts and Charting in Excel | |||
How can I add a line chart in a stacked column chart style? | Excel Discussion (Misc queries) | |||
To create a stacked column chart and group the stacked bars togeth | Charts and Charting in Excel |