If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 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 |
#2
|
|||
|
|||
100% stacked column chart shows wrong information
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 ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Karl" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|