View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
DonS DonS is offline
external usenet poster
 
Posts: 1
Default VBA can't remove drop shadows on bubble charts in Excel 2004 for Mac

We just upgraded to Office 2004 for Mac. One of our VBA programs is
now misbehaving. Unlike with the PC and earlier Mac versions of
Excel, the default option for creating bubble charts in Excel 2004
seems to create bubbles with drop shadows. You can remove the
shadows interactively. You should be able to remove the shadows using
VBA (SERIES.SHADOW=FALSE). But there seems to be a bug and it won't
work. Even if you Macro-record yourself deleting the drop-shadows
interactively, the macro won't replicate the deletion.

Why do we care about this? The key chart in software that we provide
our clients is a bubble chart, created by our VBA macros. We use
hollow (no interior fill) bubbles. We use the no-fill bubbles to let
you see what's underneath the bubble (e.g. other bubbles). However,
when the bubbles have shadows, the shadow fills the interior of the
hollow bubble, obscuring information underneath.

As far as I know, this is only an issue with Excel 2004 for Mac. Has
anyone else seen this? Any ideas for a work-around? Thanks.