how to draw "completed percentage" graphic in autocad by using excel ?

Hi all, i have a friend from planning department, he is entering data for completed activitys, he is doing this manually, we want to do it with a lisp, so i will enter some data to excel, and autocad will update itself when i open it. For example when i say %50 is done to excel, autocad will draw a hatch to show %50 completed. So im looking for something like this, any lisp or method for it ? Best regards.

Maybe a dynamic block the % is a length reflected in the X scale linked to a excel table value linked into an Autocad dwg

Hey cios106

I am really interested to hear how you got on with the above. . . . did you manage to set something up in the end? Please let me know either way, thanks.

Hey cios106

 

I am really interested to hear how you got on with the above. . . . did you manage to set something up in the end? Please let me know either way, thanks.

it was an old post, but i couldnt find any solution dear.