Draw Lines In Excel How To Draw Programmatically
Draw Lines In Excel Code In An
Draw Lines In Excel Series On A

I need to be able to plot a representation of the cross section that the users has defined.

Draw Lines In Excel Series On A

Im not sure if this would be best accomplished by plotting various series on a chart, or drawing shape objects.

Its not an application of Excel Ive seen ever, but it might be common in other places.

This is from a final plan set, and was generated using a CAD program.

What I would like is something similar but it doesnt need all the labels, dimension lines.

The Newton Excel Bach blog may be where you want to spend some good time - its an Excel for engineers site.

Heres one that addresses your immediate question: Drawing in Excel 7 Creating drawings from coordinates.

I dont know how some people have the time to write such informative stuff, but Im sure glad they do.

Draw Lines In Excel How To Draw Programmatically

Ive done plenty of custom drawing with VBA in ExcelWordPowerPoint - its pretty easy once you get the hang of it, especially if you already understand how to draw programmatically to begin with.

Modeling this problem and building some charts by hand should give you and your users a good idea if the Excel solution is going to fly.

If you cant get the graphics you want I would look elsewhere.

These have mature drawing capabilities and also charting controls in recent editions.

I have not done this but I am sure there are references on the web.

In any event, if the manually built Excel prototype looks good, it might be worthwhile to automate it with VBA.

Draw Lines In Excel Code In An

Supporting a large number of users could become onerous as it is possible to change the code in an individual file.

Also if you are going to continue to add features you might run into a wall with VBAs feature set.

The target user base is just the few engineers here in my office who are all very familiar with Excel.

So Im going to develop in VBA as an excel add-in and then if the application ends up being really beneficial, I will try to translate it into Visual Basic (maybe C).

Also, my program will be used to generate cost estimates and these engineers are accustomed to seeing cost estimates and such in spreadsheets.

By using Excel, I can write all of my output to worksheets rather than messing with pdfscustom report generating routines.

Provide details and share your research But avoid Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

Not the answer youre looking for Browse other questions tagged vba excel or ask your own question.

Draw Lines In Excel For Mac