Cluster Column Chart with floating gap

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

Similar Threads

Cluster Column Charts 1
Grouped Floating Chart 1
How do I create a combined 'cluster' and 'stacked' column chart? 1
Cluster Stacked Chart with Difference Embedded 1
cluster column chart with data point labels 2
gap width zero - double line 3
How to Combine a Floating Column Chart with Line? 1
Clustered-Stacked-Column Combo Chart With Lines 2

Top