100% stacked column chart shows wrong information
I wonder if someone can help me. I have created a table that tracks the
profitability of a particular project and Im using the table as a source for
a 100% Stacked Column graph.
The source data for the graph is in three rows:
€¢ B21:M21 - contain the names of the months from Nov €“ Oct
€¢ B22:M22 - money taken in
€¢ B24:M24 - profit
B23:M23 contains the money paid to supplier each month. I need this in the
table but I dont need to show it in the graph. I just want to show profit as
a proportion of what we bill to customers on that project.
My problem is that the graph seems to show incorrect information. Of the
total billed in November, 33% was left over as profit: the table clearly
shows around 25% profit.
Can anyone tell me what Im doing wrong?
Cheers
Karl
|