Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 ... 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cluster Column Pivot Chart | Charts and Charting in Excel | |||
How do I draw a floating cluster Gantt Chart with VBA. | Charts and Charting in Excel | |||
How to combine stacked column with a cluster column chart? | Charts and Charting in Excel | |||
Stack and Cluster Column Chart Type | Charts and Charting in Excel | |||
Stacked column and cluster column on same chart? | Charts and Charting in Excel |