Thread: How to chart a formula

Hello
Is there a way that I can plot two functions into one chart? I mean that I
only need write the first function (eg. Y = 3*x^2) in Cell A1 and the second
function (eg. Y = exp(x) +x) in Cell A2 and get both functions plotted in the
same chart.

I saw PLOT manager which was created by Tushar Mehta but it does not do what
I want.

So if anybody can help me to write a VBA code to do this task I would really
appreciate it

This is an illustration of what I want
http://phpaw.com/myscrpit/milt-up/jp...1123870575.jpg

Hi,

Maybe Jan Karel Pieterse example will help. Also includes a link to
Stephen Bullens similiar approach.
http://www.jkp-ads.com/Articles/ChartAnEquation00.htm

Cheers
Andy

Ali Baba wrote:
> Hello
> Is there a way that I can plot two functions into one chart? I mean that I
> only need write the first function (eg. Y = 3*x^2) in Cell A1 and the second
> function (eg. Y = exp(x) +x) in Cell A2 and get both functions plotted in the
> same chart.
>
> I saw PLOT manager which was created by Tushar Mehta but it does not do what
> I want.
>
> So if anybody can help me to write a VBA code to do this task I would really
> appreciate it
>
> This is an illustration of what I want
> http://phpaw.com/myscrpit/milt-up/jp...1123870575.jpg
>

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Thanks Andy

I tried using this method several times but I was unsuccessful. So I think
VBA is more suitable to me.

I am doing this as part of my project which I am asked to plot two functions
and then calculate the area under the curves.

If you can help I would be so pleased.

Hi,

I was able to add another formula to the example workbook and chart it
in the same chart as the existing one. If you email me I will send you
an example.

Cheers
Andy

Ali Baba wrote:
> Thanks Andy
>
> I tried using this method several times but I was unsuccessful. So I think
> VBA is more suitable to me.
>
> I am doing this as part of my project which I am asked to plot two functions
> and then calculate the area under the curves.
>
> If you can help I would be so pleased.
>

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info