Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
bubble charts from an excel cube function table that randomly fail | Charts and Charting in Excel | |||
bubble charts in Excel 2007 | Charts and Charting in Excel | |||
Bubble Charts | Charts and Charting in Excel | |||
Bubble Charts in Excel | Charts and Charting in Excel | |||
How do i "bring to front" bubbles in excel bubble charts which ar. | Charts and Charting in Excel |