| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Actual vs Budgeted - Stacked Bar Chart
I am trying to generate a stacked bar chart (of sorts) for the following
information: Country: <countryname Actual Q1: $150,000 Actual Q2: $87,500 Actual Q3: 0 Actual Q4: 0 Budgeted: $1,775,000 *I have multiple countries as well - but if I can sort out one, I'll be fine* What I'm trying to show is the usage of the Overall Budget by Quarter: ___ ||||| ||||| ||||| ----- |Q2| | | ----- | | |Q1| | | ------ The ||||| part is the unused budget (Budgeted - SUM(Q1:Q4)) Q1 value is the Actual amount above. Q2 value is the Acutal amount above. Q3 and Q4 would both have 0 values. Is there a way to set this up to achieve what I'm looking for? I know its possible, the question is, How? Thanks in advance. -- Dawg House Inc. "We live in it, therefore, we know it!" |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Actual vs Budgeted - Stacked Bar Chart
You need to have five items to plot, plus the budget, plus the category
label. So you need a seven-column table. Column 1 is the category label (i.e., the country). Columns 2-5 are the actuals for Q1-Q4. Column 7 is your total budget, and column 6 is the budget minus the sum of the actuals. Make the stacked plot using columns 1-6, making sure the first column is used for category (X axis) labels. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Dawg House Inc" wrote in message ... I am trying to generate a stacked bar chart (of sorts) for the following information: Country: <countryname Actual Q1: $150,000 Actual Q2: $87,500 Actual Q3: 0 Actual Q4: 0 Budgeted: $1,775,000 *I have multiple countries as well - but if I can sort out one, I'll be fine* What I'm trying to show is the usage of the Overall Budget by Quarter: ___ ||||| ||||| ||||| ----- |Q2| | | ----- | | |Q1| | | ------ The ||||| part is the unused budget (Budgeted - SUM(Q1:Q4)) Q1 value is the Actual amount above. Q2 value is the Acutal amount above. Q3 and Q4 would both have 0 values. Is there a way to set this up to achieve what I'm looking for? I know its possible, the question is, How? Thanks in advance. -- Dawg House Inc. "We live in it, therefore, we know it!" |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ?make a combo chart with 1 stacked bar and 1 not stacked, + show t | Charts and Charting in Excel | |||
| Need % of Actual over Budgeted. Budgeted 0 actual 160 | Excel Worksheet Functions | |||
| How can I combine a stacked bar chart with stacked colum chart? | Charts and Charting in Excel | |||
| To create a stacked column chart and group the stacked bars togeth | Charts and Charting in Excel | |||
| How can I create a stacked bar chart with stacked bars side by | Charts and Charting in Excel | |||
Linear Mode
