excel graphic add-ins?

[rasosina]

Hi,

I tried to make a post before but i don't think it worked.

Anyway, i'm trying to plot shapes in excel.. like lets say a circle.

Now i know it's possible to plot those shapes in excel using the simple scatter chart, but the problem is that the graphing feature of excel is not powerful enough. I want to be able to zoom in and out and move the view around on the graph.

I wanted to know if there are any graphic add-ins that could be downloaded or purchased to use instead of using the "insert chart" feature of excel.

Thanks

 

[RWF7437]

Yes you can.

Go to <view><toolbars> and click on <drawing>

You'll get a drawing tool bar at the bottom of the screen which allows you to draw many shapes such as circles, rectangles, ellipses, etc. With these you can draw sketches of almost anything. I've even seen some passably good art done this way.

good luck

 

[corus]

You can use an acticeX control such as Tchart for Visual Basic and use it within a Macro

corus

 

[joerd]

I think you might need some dynamic scaling. Check out

http://www.peltiertech.com/Excel/Charts/AxisScaleLinkToSheet.html

And otherwise, you might find what you need on that website.

Cheers,
Joerd

Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.

 

[BigInch]

If you haven't seen this thread 3D graphics, have a look at the macro code in the sheets referenced there.

thread770-211542

http://virtualpipeline.spaces.msn.com

"What gets us into trouble is not what we don't know, its what we know for sure" - Mark Twain

 

[rasosina]

great thanks a lot for your helps guys I really appreciate it.