How to chart a series of formulas?

[Marcus Leon]

Hi, does anyone know how to chart a series of formulas?

I currently chart cells in column C. Each cell in column C contains
a formula - "=A1+B1", "=A2+B2", "=A3+B3", etc.

I would like to do away with column C and just get the chart to
calculate the values that are being displayed automatically. How can
you do this?

Thanks

 

[Jon Peltier]

Marcus -

Charts aren't that smart, and worksheet ranges are pretty cheap. Compute the data in
the worksheet, and plot the column with the formulas.

Of course, you could name your ranges (Adata and Bdata) by selecting each range,
typing a name in the Name box (just above cell A1 on the Formula bar), and pressing
Enter. Then define a new name (Ctrl+F3), call it Cdata, and define it as
=Adata+Bdata. When making a chart, in step 2 of the wizard, click on the Series tab,
click Add, and in the Values box, enter =MyBookName.xls!Cdata.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[Marcus Leon]

Thanks Jon, that works great. How would I create a formula like
"=A1+B2", "=A2+B3", "=A3+B4", etc?

Marcus.

 

[Jon Peltier]

Use the worksheet. As soon as a defined formula gets at all complicated, it becomes
severely difficult to understand and maintain.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______