CAD Forum - tips, tricks, discussion and utilities for AutoCAD, Inventor, Revit and other Autodesk products [www.cadforum.cz]
Cesky English Deutsch
Login/Register:
 Visitors: 2112 
Become a fan of CADforum on Facebook Follow us on Twitter
Budweiser blog YouTube channel
Web server of the CAD Studio company (formerly: Xanadu)

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    1384×  
Comments   Tell a friend
Prices - CAD eShop:
Koupit AutoCAD
Koupit AutoCAD LT
applies to: AutoCAD · AutoCAD LT ·

See also:
Tip 12479:PkLength - export line lenghts to Excel.
Tip 12350:PkArea - acreage of closed areas from DWG to Excel.
Tip 11982:Creating table with parcel numbers and areas - AreaTab.
Tip 11896:How to drive dyn.block parameters or constraints from Excel?
Tip 10693:List of blocks (incl. nested blocks) used in a DWG drawing.
Selected tip: 3DConstruct - converting a 3D mesh to a frame construct


Back   All CAD Tips All CAD tips&tricks

How to identify parts and assemblies imported from STEP/IGES? « | » How to use conditional parameter values in Fusion 360?


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:
Link your AutoCAD texts with Excel tables/sheets. Export. Change. Import.
Try DwgText 2020 More info


Please use these tips at your own risk.
CAD Studio is not responsible for possible problems that may occur as a result of using any of these tips.
TOPlist
CAD Forum - tips, tricks, help, how-tos and FAQ for AutoCAD, LT, Inventor, Revit, Map, Civil 3D, Fusion 360, 3ds max and other Autodesk software (support by CAD Studio)
Copyright ©2020, CAD Studio s.r.o. - Autodesk PLATINUM Partner & Training Center & Consulting Services Partner
CAD Tips and Tricks • Cesky • Contact webmaster@cadstudio.cz • Advertise with us • CADstudio online privacy