Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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. – allquixotic Feb 20 '13 at 18:47

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

Your Answer


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.