I want to use equations to generate the chart. Is it possible?

[Guest]

I wanted to create equation withing chart and use it to develop charts.
Currently we are using excel cells (rows and columns) to generate charts. I
am looking for equations(say maximum 2 degree) to be inserted into the chart
area and use it to generate chart.

Say for example, I have equation y=x2 into the chart. I get options to
insert values of x and chart window automatically calculate y value and draw
the curve of (x,y) values on chart. If required I could edit the equation and
change it.

It is just opposite to 'Trendline' in nature.

 

[Jon Peltier]

The easiest way is to keep using the cells for the calculations. Kind of
their job, and it's easier to see what's wrong if it doesn't come out right.

However, Stephen Bullen and Tushar Mehta have written about techniques to do
what you are asking using dynamic names:

http://oaltd.co.uk/DLCount/DLCount.asp?file=ChtFrmla.zip
http://tushar-mehta.com/excel/software/plot_manager/index.html

- Jon

 

[Guest]

Hi Varun,

Many years ago I suggested the following idea:

1. Define a name that refers to a range in your other workbook, for example
='E:\[Invest2007-2003.xls]SmartTags'!$A$1:$F$20

You can do this by opening both workbooks and choosing Insert, Name, Define.
I named the above range Other. Initially the name does not include the path
but when you save and close the Invest2007-2003.xls file (the target file)
the path is added.

The range you define should be as large as necessary to cover all the data
in the target sheet.

2. In your spreadsheet you can use the formula =INDEX(Other,3,3) to bring
back the entry at cell D4, the entry that is 3 rows down and 3 columns to the
right of the top left corner of the range A1:F20.

This link works whether the file is open or not.

See if this helps you.