Cluster Column Chart with floating gap

X

Xtian

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!
 
A

Andy Pope

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top