Drawing shapes (lines, boxes, triangles) using vba in an excel graph

You should delete this post and re-post in the spreadsheets forum.

Search in that forum; there was a post about doing graphics in Excel

TTFN (ta ta for now)
I can do absolutely anything. I'm an expert! faq731-376 forum1529 Entire Forum list

Hi,

Also, there ares some additional considerations.

Primarily, whether with or without a graph, the process of placing a geometric object on a sheet ought to be generated using a table of data.

Yes, you can use an Excel Chart (graph). This puts a ChatObject Object on your sheet as the mechanism to display data in various ways. If you only want to display geometric objects, the various Chart Objects like, Chart Borders, Chart PlotArea, Axes, Titles, Grid Lines could be coded to be not visible. Such a Chart or Charts can be positioned anywhere on a Sheet. This can all be done via VBA.



Skip,

_{Just traded in my OLD subtlety...
for a NUance!}