Google Docs Chart

[Igor Lemberg]

Hi everybody, I would really appreciate your help.

I need to create a chart but it gets tricky since I need to put some red zones in the chart, I don't even know if it's possible.

I have data about subscribes, leads and sales. Also how much I spend for each one, but it's later.

Good value for me is when the ratio of leads to subscriptions is 1 to 5, and sales to leads is 1 to 10

I want to have a chart that shows the whole month data for all three values, but also, I want to be able to see, whenever this ratio is going lower.

For exapmle:

1/6 - subs - 100, leads 30, sales 4 (good)
2/6 - subs - 150, leads 70, sales 10 (good)
3/6 - subs - 100, leads 15, sales 1 (bad)


So on the chart I want to see that on the third something happened and needs to be fixed.

I know it's a tricky one, I tried to do it myself, but gave up.

Hope for your help!