# 100Percent Stacked Colum Chart - Auto Adjusting Its Values

## Recommended Posts

I have a 100 percent stacked column chart. One of the column values in the dataset goes beyond 100.., ie.,102. The SWF auto adjusts itself, to get the maximum of 100%. Its fine.

I wanted to understand what is the logic behind this., We have an export mechanism from the charts, wherein after export we find a mismatch in the data value. To avoid this, we have decided to implement the same logic as how the SWF is doing in our application, so that the generated XML will always have a maximum of 100.

##### Share on other sites

Hi Sundhar,

For your data the chart forms a ratio 100:102 and percentage of each value scales to this factor.

100% Stacked Column chart represents numbers in percentage where each column is 100% and all the stacked segments of that column compose to 100% or all values of the column sums up to form 100%. The most important thing is - you are not required to provide your values in percentage. The chart will always represent the percentage share of each value with respect to the column it is in. You can imagine each column to be a pie chart flattened into columns and each value on that column a slice of the pie - thus each column of the chart is a different pie chart.

Consider these values provided for a single column of a 100% stacked chart:

15,30,5

The column will show the percentage equivalent - 30%, 60% and 10% (all totaling to 100%)

In simple arithmetic the formula can be - value/totalOfValues * 100

Now, if you change the values to: 15,30,6

The newly calculated percentage values will be [15/(15+30+6)*100], [30/(15+30+6)*100], [6/(15+30+6)*100] that is - ~29.41%, ~58.82%, ~11.77%.

You can see that the percentage share of each value has changed.

In your case, the chart fits all the values of the column following this proportion: 102:100::