If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Cluster Column Chart with floating gap
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! |
#2
|
|||
|
|||
Cluster Column Chart with floating gap
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 -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Xtian" wrote in message news 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! |
Thread Tools | |
Display Modes | |
|
|