Chart with series in color based on value

Is it possible to color the amount series in red if it cross above 2000000 value with the help of macro? Please help.
Attached is the sample output.

Andy Pope shows how you can do that here:

http://www.andypope.info/charts/conditionalline2.htm

Hope this helps.

Pete

Thank you. I tried creating the chart template (Attached sample). Is it possible to create the same through macro or have this chart shown in new excel workbook that is saved to our folders. Please help. I am trying to have both the data and chart that can be shown into new workbook.