Cluster Column Chart with floating gap

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have a problem regarding a cluster column chart with floating gap (for an
example, see http://www.andypope.info/charts/floatinggap.htm). I want this
process to be automatic, e.g. I don't want to manually change border color
and fill color (and the other manual adjustments needed in the above
example). Is it possible to make such a chart automatic, I guess with VBA?

Thank you!
 
Hi,

Once set up the colour changes are automatic.
If you want to set it up automatically then yes VBA code will be required.
If you are not using xl2007 you can use the macro recorder to give you a
starting set of code.

Cheers
Andy
 
Back
Top