If you simply window off the geometry there is a good possibility the prompt order will not be as desired. When building the block definition, the selection order is the key. How do I control the prompt order for attributes? Erase the outer border and background solid to reveal a good looking collection of native geometry.In AutoCAD, issue the PASTESPEC command again, choose AutoCAD entities.In AutoCAD, right click on the chart and choose CUT.In AutoCAD, issue the PASTESPEC command, choose Excel Chart, your only choice at this point.

In Excel, copy your graph to the clipboard.

Use this procedure to 'shake off' the OLE. When you paste pie/bar graphs from Excel into AutoCAD, they can exhibit all the problems of a typical OLE insert, including plot rotation, etc. If the link is not required, you may be able to get more of the data into AutoCAD by using the Paste Special option from the menu and choosing an option like 'AutoCAD Objects'. When you use the ole link, you lose rows and/or columns. When you look at the clipboard viewer, you should see that the Windows clipboard has limited the data when presented in certain 'flavors'. It will be in the System Tools section of the Windows Setup tab. If you don't have this program you will need to use the Add/Remove Programs applet of the Windows Control Panel to add it. You will find the clipboard viewer in the accessories or system tools section of the Windows start menu. To see a graphical example of this, select a large range in the spreadsheet, then look at the clipboard viewer. There is a limit, and that limitation is not necessarily AutoCAD's fault. Is there a limit on rows/columns from my OLE spreadsheet? All materials are to be considered 'as-is', and use of any information should be considered as AT YOUR OWN RISK! DotSoft makes no warranty, either expressed or implied, as to the fitness of this information for any particular purpose. FURTHERMORE, BY USING THIS INFORMATION YOU AGREE TO HOLD DOTSOFT HARMLESS FROM SUCH CLAIMS. You may not post this information online (including web sites, ftp sites, bulletin boards, and other online services) for public viewing, and you may not publish in print for public viewing without prior written consent of DotSoft.ĭISCLAIMER: DOTSOFT DISCLAIMS ANY AND ALL LIABILITY FOR ANY DAMAGES ARISING OUT OF THE USE OR OPERATION, OR INABILITY TO USE ANY INFORMATION AVAILABLE HERE. You may not sell, lease, or mass-redistribute this information on disk or electronically. You are free to use the information listed here, but it is copyrighted works and are not public domain.

Autocad lisp copy text to clipboard