We're running AutoCAD 2010 at our office. We often need to create charts displaying information that was calculated in an excel spreadsheet. I can import the spreadsheet using the datalink and table functions, but it does not meet our graphical standards. I'd like to make a chart with lines and text that meets our requirements, but then use fields to extract data from the table. I was able to extract numbers using FIELD CATEGORY: Objects, then selecting FORMULA, then CELL. The problem is if it is just a number like '33' it works fine. If it has any other non-numberical text in it, it does not work and the field displays '####'.
Does anyone have a workaround for this?
Thanks in advance.