VBA : excel chart

**david2004** · January 26th, 2004

hi all..

i like to ask if i have a table with many columns of values which will have functions inserted into the cells.

Problem:

How to create a line chart such that the chart compares Column C values with Column E values?

Sorry i am really a newbie.. PLs help

***Andy Pope*** · January 26th, 2004

Hi david2004,

If you use the chart wizard you can do the following.
Select the chart type XY scatter.
Select the values from column C then whilst holding the CTRL key select the values from column E.

Cheers
Andy

**david2004** · January 26th, 2004

hi andy

Thx for helping..

then if i want to do a polar plot.. as in to show the points around a circle such that i can show the difference between the calculated points from the actual circle at a particular radius.how can i plot the actual circle and the differentation?

***Andy Pope*** · January 26th, 2004

Excel charts do not include a built-in polar plot.

If you have a set of data containing the angle and radius for each point then you can use some forumla to plot the points on an xy scatter chart.

I just happen to have an addin to do this

http://www.andypope.info/charts/polarplot.htm

Cheers
Andy

**david2004** · January 26th, 2004

hi andy..

you are really a professional. But i dont really understand how to write a code or formula for my case.

on your link, i cant see the polar plotter page when i download the workbook.

please help.
eager to hear from you