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

Similar Threads

Doughnut Chart linked with the slicer in the pivot table 0
Cluster Column Charts 1
Bar Chart with Data Elements 1
Cluster Stacked Chart with Difference Embedded 1
How do I create a combined 'cluster' and 'stacked' column chart? 1
Grouped Floating Chart 1
cluster column chart with data point labels 2
Cluster Column Pivot Chart 0

Top