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

V

Varun

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.
 
S

ShaneDevenshire

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top