How to chart a series of formulas?

  • Thread starter Thread starter Marcus Leon
  • Start date Start date
M

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
 
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/
_______
 
Thanks Jon, that works great. How would I create a formula like
"=A1+B2", "=A2+B3", "=A3+B4", etc?

Marcus.
 
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/
_______
 
Back
Top