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

  • Thread starter Thread starter Greg
  • Start date Start date
G

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
 
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
 
That works great! Thanks
Greg

Tushar Mehta said:
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
Click to expand...
 
Back
Top