If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
stacked charts %
Hi,
I'm trying to put a budget review in a stacked chart. Suppose I have four columns of data: 1) total budget, 2) total spend, 3) total committed, 4) budget left. Now I would like to make a chart that gives me 2,3 and 4 as % of the total budget. The 100% stacked column chart seemed appropriate. However (and unfortunately) it is possible that 2+3+4 exceed the total budget and I do not succeed in getting this right in this type of chart. Any suggestions? I looked at the http://www.andypope.info/charts/StackColTotal.htm but it does not give an explanation on the % chart. Thanks |
#2
|
|||
|
|||
Hans,
I'm not sure my example is suitable for your problem. I think you need to create a clustered stack chart. Where 1 is a stack by itself clustered next to a stack containing values 2+3+4. That way you can see if the total of 2+3+4 exceeds the value of 1. Have a look at Jon's page for guidance. http://peltiertech.com/Excel/ChartsH...sterStack.html Cheers Andy Hans wrote: Hi, I'm trying to put a budget review in a stacked chart. Suppose I have four columns of data: 1) total budget, 2) total spend, 3) total committed, 4) budget left. Now I would like to make a chart that gives me 2,3 and 4 as % of the total budget. The 100% stacked column chart seemed appropriate. However (and unfortunately) it is possible that 2+3+4 exceed the total budget and I do not succeed in getting this right in this type of chart. Any suggestions? I looked at the http://www.andypope.info/charts/StackColTotal.htm but it does not give an explanation on the % chart. Thanks -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
|
|||
|
|||
Thx for the suggestion Andy, but I used yet another approach. I just put in
a few more columns in the datasheet which represent the % value of 2,3 and 4 compared to 1. Then I put these three sets of data in a 100% stacked column chart. Your approach didn't suit me since the absolute values of the different budgets differ a lot (factor 1000). So putting them in one chart did not give me a clear picture. Thanks "Andy Pope" wrote: Hans, I'm not sure my example is suitable for your problem. I think you need to create a clustered stack chart. Where 1 is a stack by itself clustered next to a stack containing values 2+3+4. That way you can see if the total of 2+3+4 exceeds the value of 1. Have a look at Jon's page for guidance. http://peltiertech.com/Excel/ChartsH...sterStack.html Cheers Andy Hans wrote: Hi, I'm trying to put a budget review in a stacked chart. Suppose I have four columns of data: 1) total budget, 2) total spend, 3) total committed, 4) budget left. Now I would like to make a chart that gives me 2,3 and 4 as % of the total budget. The 100% stacked column chart seemed appropriate. However (and unfortunately) it is possible that 2+3+4 exceed the total budget and I do not succeed in getting this right in this type of chart. Any suggestions? I looked at the http://www.andypope.info/charts/StackColTotal.htm but it does not give an explanation on the % chart. Thanks -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
comparison charts - stacked graphs | ehpando | Charts and Charting | 1 | June 22nd, 2004 01:57 AM |
Stacked Area Charts | McBeastly | Charts and Charting | 2 | May 25th, 2004 05:43 PM |
Multiple stacked bar charts | Gargamil | Charts and Charting | 4 | February 26th, 2004 01:57 AM |
Multiple Stacked Bar Charts, Data Organitation | Bull Splat | Charts and Charting | 1 | November 11th, 2003 05:13 PM |