Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drawing on a Chart
I am using VBA in Excel to model some alignment errors in a test fixture.
The output is a multiple series scatter chart of the data. If I calculate the center and radius of a circle that fits a part of the data (least squares fit method), how can I draw the circle on a chart? Ron H. ----------------- www.Newsgroup-Binaries.com - *Completion*Retention*Speed* Access your favorite newsgroups from home or on the road ----------------- |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drawing on a Chart
Hi,
The simplest way is to use a series to draw the circle. Add an extra data series to the chart plotted as xy-scatter line no markers. You can calculate the circle using basic trig formula. Assume, X Center in cell D1 Y Center in cell E1 Radius in cell F1 Range G1:G360 Circle XY points in range G1:H360 G1: =$D$1+(COS(ROW()*(PI()/180))*$F$1) H1: =$E$1+(SIN(ROW()*(PI()/180))*$F$1) copy down for 360 rows. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Ron H." wrote in message ... I am using VBA in Excel to model some alignment errors in a test fixture. The output is a multiple series scatter chart of the data. If I calculate the center and radius of a circle that fits a part of the data (least squares fit method), how can I draw the circle on a chart? Ron H. ----------------- www.Newsgroup-Binaries.com - *Completion*Retention*Speed* Access your favorite newsgroups from home or on the road ----------------- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drawing a line on a chart | Charts and Charting in Excel | |||
Drawing shapes in a chart | Charts and Charting in Excel | |||
Drawing on a chart | Excel Worksheet Functions | |||
Drawing a line in bar chart | Charts and Charting in Excel | |||
= Drawing more lines in a OHLCV chart = | Charts and Charting in Excel |