Excel ERIC - Emission Reduction Investment Curve

[alishaikhji]

I am trying to make an ERIC curve (

http://drgreglavery.files.wordpress.com/2011/01/110129-eric-diagram-for-blog-page-v1.jpg)

in Excel 2003, but can't really do it.

I have all the required data available, but finding no way to plot it. Could someone please help?

 

[IRstuff]

You could read the manual.

Unless you care to explain what problem you're actually having

TTFN
faq731-376

 

[alishaikhji]

Please see the attached file.

Issue 1: I want to use a logarithmic chart, but I use the logarithmic chart, I lose the vertical lines.

Issue 2: I want to plot the cumulative IRR in the same chart (as in the one picture I attached before), but I don't know how can I add another curve on the same graph.

Regards,

Ali

 

[LiteYear]

Issue 1: I want to use a logarithmic chart, but I use the logarithmic chart, I lose the vertical lines.

Did you try reading the error message?. You're trying to plot down to 0, which doesn't exist on a logarithmic axis. Change the lower y values to 1 instead.

I want to plot the cumulative IRR in the same chart (as in the one picture I attached before), but I don't know how can I add another curve on the same graph.

Um... the same way you added the 2nd curve? And the 3rd, 4th, 5th, 6th and indeed, the 11th additional curve? I think you need to do a bit of experimenting first or be a bit clearer about where you're getting stuck.