Is it possible to generate a chart from a formula. or: Can I define and plot my own Trendline?

[Greg]

I'd like to generate a circle on a chart by entering the radius of the
circle into a cell.


Thanks in advance for any help,
Greg

 

[Tushar Mehta]

Suppose the radius is in cell A1.

Then, in B1 enter the formula =ROW()-1. In C1 enter =B1/180*PI(), in
D1, =$A$1*COS(C1), and in E1 =$A$1*SIN(C1). Copy row 1 to 2:361. Plot
D1:E361 in a XY Scatter chart.

Once done, adjust the chart so that the x and y axis have the same
min/max values. Also, select the plot area and extend it as close to
the chart area as possible. Finally, select any cell. Then, hold down
SHIFT and select the chart. Now, select Format | Object... From the
Size tab, set the height and width to be equal.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[Greg]

That works great! Thanks
Greg

Suppose the radius is in cell A1.

Then, in B1 enter the formula =ROW()-1. In C1 enter =B1/180*PI(), in
D1, =$A$1*COS(C1), and in E1 =$A$1*SIN(C1). Copy row 1 to 2:361. Plot
D1:E361 in a XY Scatter chart.

Once done, adjust the chart so that the x and y axis have the same
min/max values. Also, select the plot area and extend it as close to
the chart area as possible. Finally, select any cell. Then, hold down
SHIFT and select the chart. Now, select Format | Object... From the
Size tab, set the height and width to be equal.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[Tushar Mehta]

You are welcome. Glad to be of help.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

That works great! Thanks
Greg

{snip}