Problems with Line-Area chart

[dafan]

Hi all.

I wanted to colour an area between 2 line graphs and had no trouble at all at a simple table following this guide

Problem is it doesn't seem to work when making 2 areas in one graph!

When I first colour the area between the lines of Charge/order and Labour/order, and thén Charge/item and Labour/item, my graph ends up like this (Notice how the light-blue area should be lower, between the green lines):

When I build the graphs the other way around (first /item, then /order), the first area lines up good, but the second is wrong...

Any ideas what is causing this?

PS1: Sorry about the different colours, hope it's still clear.
PS2: Don't mention the righthalf of the graph, there is still some data missing on weeks 23 and 24, therefore it just slopes to zero.

 

[Jon Peltier]

You need four area series:

blank1: value = labor/item
profit1: value = charge/item minus labor/item
blank2: value = labor/order minus charge/item
profit2: value = charge/order minus labor/order

Do the appropriate calculations, plot them in this order, then format as appropriate.

 

[dafan]

Thanks, that worked great.

How did you, of all people, find this thread Lucky me!