Chart Errors

S

Scaccia

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?
 
B

Barb R.

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sorting a stacked column 0
Display percent and value on stacked column chart 0
Stacked Bar Chart 1
stacked column chart 4
Excel line chart not displaying correctly 1
Pie Chart 4
X-Axis Units Disappear in Stacked Area Chart (Excel 2007) 0
Multiple chart series for Pivot Chart 0

Top