Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations SDETERS on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

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

Status
Not open for further replies.

QuijoteMx

Computer
Oct 2, 2020
1
Hi!
I've found one post in this forum that teaches how to draw polylines in a spread sheet.
the coordinate system is located in the upper left corner of the sheet.

Is there a way to do the same but using the coordinate system provided by an excel chart?

Thank you

O. Molina
 
Replies continue below

Recommended for you

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,

[glasses]Just traded in my OLD subtlety...
for a NUance![tongue]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor