Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have a series of figures that look like the "Basic Radial" SmartArt Graphic in Excel.

My goal would be to be able to change the width of each line using values in values found in my worksheet, thus in a dynamic fashion, so that I don't have to go and do this line by line. I've been going through other posts describing how to do this for column widths, but these workarounds don't seem to correlate with what I"m trying to do. Any and all help that woud save me hours from doing this would be much appreciated.

share|improve this question
    
Figures? Like, charts? You could write a macro in VBa to update them. –  ÃŁŁǫǛȉЖΦΤїҪ Feb 20 '13 at 18:47
add comment

1 Answer

As suggested, you need a vba macro. The easieast way is recording a macro and then manual change the width. After this study the recorded macro and try to optimize it.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.