To answer your question about - I am a complete VBA
novice (just figuring out how to enable VBA in Excel right now; I do have a
programmer/IT background though).



Not sure what you mean by dynamic (that is my ignorance BTW!). I expect to
import the data  into a worksheet (from MS Project), then run a Marco and I
get the chart. The data would be refreshed periodically (weekly?) and the
chart readied for print. My guess it is not dynamic based on your definition
below.



If the macro/VB code  is already written, I could make changes like set the
right color, range etc. It is my intention to take a VBA class, but right
now, I am stuck with an immediate need that has to be fulfilled. I thought
this could be done w/o VB code, but right now, it seems not.