100% stacked column chart shows wrong information

  • Thread starter Thread starter Karl
  • Start date Start date
K

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
 
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
 
Back
Top