CAD Forum - tips, tricks, discussion and utilities for AutoCAD, Inventor, Revit and other Autodesk products [www.cadforum.cz]
CZ | EN | DE
Login or
registration
  Visitors: 7906

CAD tip CAD tip # 12641:

   
Question CAD 
 %  platform  category 
Q - question

How to copy a graph from Excel to AutoCAD?

A - answer A graph created on a sheet in an Excel workbook can be copied over to AutoCAD using different methods. The classic copy/paste transfers the selected graph just in a form of an OLE object, which is not suitable for processing in CAD applications.

XLS-DWG

But with the command PASTESPEC (Clipboard > Paste > Paste as) you can pasete the copied graph from Excel right as AutoCAD objects. In the dialog "Paste As", choose "AutoCAD Entities" and complete the copy-paste operation.

XLS-DWG

The individual components of the copied graph, including the curve shape, are pasted as polylines and texts in the DWG drawing.

XLS-DWG

XLS-DWG

Some Excel graph types (e.g. 3D graphs, tree maps, funnel) cannot be copied this way.

ACADLT
100% *  CAD 
14.6.2020    18777×  
Prices - CAD eShop:
applies to: AutoCAD · AutoCAD LT ·

See also:
Tip 13855:DBXscanLayers and DBXscanBlocks - bulk report content of DWG files in a folder.
Tip 13784:Export block coordinates to a table. How to use the DATAEXTRACTION command in AutoCAD LT?
Tip 13757:Bulk editing of drawing properties (DWGprops) from Excel.
Tip 13683:Limitations of the LISP language (AutoLISP, VisualLISP) in AutoCAD LT - what to watch out for
Tip 13522:LookupXLS - populating DWG texts from Excel spreadsheets.


Back   All CAD Tips



Have we helped you? If you want to support the CAD Forum web service, consider buying one of our CAD applications, or our custom software development offerings, or donating via PayPal (see above). You may also add a link to your web - like this "fan" link: CAD Forum - tips, utilities, blocks for Autodesk products
CAD:    OS:    Categ: 
Text:  FAQ glossary   



Featuring:
Increase your productivity with our set of BIM add-on functions for Autodesk Revit
CADstudio Revit Tools More info


Please use these tips at your own risk.
Arkance Systems is not responsible for possible problems that may occur as a result of using any of these tips.
TOPlist