On Wed, 13 Aug 2008, in microsoft.public.excel.charting,
TWB said:
It appears that Excel is charting the Spent to Date + Total Value = "Value"
then Spent to Date / "Value". For example for Acct 1002 instead of the
Stacked bars showing that 81% is spent the chart is showing 45% which is
40967 + 50000 = 90967 Then 40967 / 90967= 45%. I hope this is making sense.

If you are using the 100% Stacked Bar Chart and you would like the Spent
to date to appear as a percentage of the total available, you must make
the second value be Total *Not* Spent to date, so that the two values
together make up the total available.

So your charted values must be:

Spent Unspent
1001 160,079 89,921
1002 40,967 9,033
1003 50,240 49,760
1004 0 50,000
1005 8,559 21,441
1006 2,727 27,273
1007 10,503 19,497
1008 7,194 22,806
1009 310,205 119,795

--
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.