Contour Plot Grids

[Guest]

Hi, All --

I've programmed a finite difference solution to the 2D Laplace equation in
Excel. I plot the equipotential lines in a contour line chart. So far, so
good. The problem is that there is a grid underlying the contour lines.
This grid has the same line weight as the contour lines themselves. Note
that these are NOT x- and y-axis grid lines, which are turned off. It
appears that this is the grid used by Excel to calculate the contours. The
problem with this is that I need to print the chart out and draw flow lines
orthoganal to the contour lines -- this is next to impossible with the grid
in the background.

Thanks.

Matt

 

[Andy Pope]

Hi,

Does this help?
http://j-walk.com/ss/excel/tips/tip102.htm

Cheers
Andy

 

[Guest]

Andy --

Thanks for the response, but that's not quite it. I am interested in
plotting contour lines only without the shading. If I go through those
steps, the gridlines are indeed removed, but so are the contour lines,
leaving me with a blank plot.

Any other tricks?

Matt

 

[Andy Pope]

Have a look at Fernando Cinquegrani page. He has a contours add-in.
http://www.prodomosua.it/ppage02.html

Cheers
Andy

 

[Jon Peltier]

Fernando's is a much nicer contour generator.

The built-in Excel contour chart either draws both contours and the grid, or
neither. I guess it generates a set of polygons, which share contour lines
and gridlines as their borders. To draw the borders, you must draw all
lines.

- Jon