Chart Errors
 

I have created a chart using 100% stacked columns. I want my values to show
the % each value contributes to a total. I.E. Overage, Current Collections
and Total Goal. The chart looks great; however, whenever I update my current
collections, the percentage doesn't calculate correctly. The chart seems to
be adding all values together to come up with the percentage need and the
goal doesn't seem to shrink. Any ideas?

Are Overage, Current collections and Total Goal stacked on top of one
another. If so, the % calculated would be based on the total of all three.

"Scaccia" wrote:

I have created a chart using 100% stacked columns. I want my values to show
the % each value contributes to a total. I.E. Overage, Current Collections
and Total Goal. The chart looks great; however, whenever I update my current
collections, the percentage doesn't calculate correctly. The chart seems to
be adding all values together to come up with the percentage need and the
goal doesn't seem to shrink. Any ideas?