100% stacked column chart shows wrong information

[Karl]

I wonder if someone can help me. I have created a table that tracks the
profitability of a particular project and I’m 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 don’t 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 I’m doing wrong?

Cheers

Karl

 

[Jon Peltier]

Do you want a Stacked Column chart, not a 100% Stacked Column chart? In
fact, it makes more sense to use clustered columns, because profit isn't
added to (stacked on) revenue.

- Jon