Geek asks and answers

How to create a percentage chart in excel similar to a "100% stack column" but with one variable versus total cost

I thought a lot about this case, I need to build a series as a percentage of another series.

for example, series A is capacity and B is use. I need a percentage graph of B on A. Initially, I did this by creating a 100 percent stack with a series of B vs (AB). I calculated (AB) in a separate column and used this as a series for this purpose. So far so good.

But now I want to create some diagrams like this (say, 12 different graphs for 12 months of use). I have 12 columns of usage data and one column of fixed bandwidth data.

Is there a way to automatically generate this chart without creating 12 intermediate columns with the formula. It seems logical that Excel should have a chart type for representing A on B, just as they have one for A, B on A + B.

Sorry if I'm too long or confusing in my description. I did my best to explain.

+3
source share
3 answers

, . Excel 2007 ( , ). 3 , 1 , , . . , . , 100% wahla, . , !

+1

Excel , Microsoft . .

Excel , . A B, .

0

I would make sure not to change the ranges on the sheet at all. Write a new function that creates the changed range data that you need so you can return it and use it inside the ApplyTemplate method when creating the chart. The only drawback to this is that you will need to run the macro button / vsto to update the chart. as opposed to getting this behavior for free with a snap to a sheet.

-1
source

More articles:


All Articles