Hi all,
I am working on a VBA report that generates reports with pivot tables, pivot charts, and regular charts. But when these charts are being generated I format them and it looks really ugly and choppy. I tried the .Visible = false property and that doesnt work as soon as I start making modifications to the chart. (Each chart is being placed onto a worksheet, instead of a separate chart on its own tab... maybe this changes things... no idea).

Maybe I can set some sort of coverup sheet at visible constantly till all is done?? I use "Select" a lot and this seems to change the visual focus as well (as if I had clicked on the chart itself).

I'd appreciate any help... I only got a couple more weeks till this bad boy has to be done. Any input is welcome.

Thanx in advance,
cLocKwOrk