The inflexible and ugly built-in custom combination charts have been removed
from Excel 2007, but you can make most any combination chart you want.
For a floating bar chart, you need two series, one for start, the other for
duration (i.e., end minus start). Create a stacked bar chart, then format
the start series to be invisible (no border, no fill). Avoid the lame 3D
effects of the old built-in custom floating bar chart from old versions of
Excel.
Is anyone else amused by the "built-in custom" oxymoron?
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -
http://PeltierTech.com
_______
"drs" wrote in message
ups.com...
Egad! I have some office automation code that is no longer working
with Excel 2007. The main problem is that there is no longer a
definition of "Floating Bars" chart type.
Pseudo code is like:
.ActiveChart.ApplyCustomType(xlBuiltIn, "Floating Bars")
Anyone have any ideas?